Forum Discussion
Solved
Help with Formulae IF statements
Please could someone help me with concatenate IF statements. E4 = 160 E5 = 149 B10 = 137 If E4 is greater than B10, give me E5 x 2 /100 or if E4 is less than or equal to B10, give me E5 /10...
pebbles1221 That would be:
=IF(E4>B10,E5*2/100,E5/100)
pebbles1221 That would be:
=IF(E4>B10,E5*2/100,E5/100)
Thank you so much. I was making this so difficult for myself when it was clearly "if this, option 1, if not, 2nd option"
Appreciate the speedy response. Thank you again.