Excel; If statement and if true divide the value into 2 seperate columns - TechRepublic
Question
February 27, 2007 at 04:31 PM
ltraylor

Excel; If statement and if true divide the value into 2 seperate columns

by ltraylor . Updated 15 years, 2 months ago

I need to figure out how to combine an IF statement with some other kind of statement not sure.
I put for column U13:
=IF(C15=”Both”, T14*0.34, T14*0)
For column V13:
=IF(C14=”Both”, T13*0.66, T13*0)
I end up with a value in either V13 or U13 and then a 0 in the column with no value.

This discussion is locked

All Comments