Questions

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

+
0 Votes
Locked

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

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