If formula true result then divided into 2 columns
 

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 formula true result then divided into 2 columns
 

I am confused. Both formulas have the same condition thus they should
be both either 0 or the 66% and 34% of T12 respectively. Also, an
excel formula basically puts something in the cell it is in and does
not in any other way affect the spreadsheet. With all that said, your
formulas seem to be correct for what (I have understood) you want.

HTH
Kostis Vezerides

On Feb 28, 7:21 pm, Libby wrote:
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.