If formula true result then divided into 2 columns

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.
 
V

vezerid

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top