L
Libby
I am trying to write an If formula that tells me:
If the value is true then divide the total column by 34% and 66% and put
each percent in a seperate cell.
V13=IF(C13="Both", T12*0.66, T12*0)
U13==IF(C13="Both", T12*0.34, T12*0)
I did this it does not should an error but it basically says that b/c this
formula is making that cell equal 0 so it will calculate 1 column correctly
and the other will have a valueof a zero.
Is there an IF THEN kind of statement...So aggrevating becuase I am so close.
If the value is true then divide the total column by 34% and 66% and put
each percent in a seperate cell.
V13=IF(C13="Both", T12*0.66, T12*0)
U13==IF(C13="Both", T12*0.34, T12*0)
I did this it does not should an error but it basically says that b/c this
formula is making that cell equal 0 so it will calculate 1 column correctly
and the other will have a valueof a zero.
Is there an IF THEN kind of statement...So aggrevating becuase I am so close.