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 /100
I don’t seem to be able to concatenate these two formulae
=IF(E4>B10,E5)*2/100
=IF(E4<=B10,E5)/100
pebbles1221 That would be:
=IF(E4>B10,E5*2/100,E5/100)
2 Replies
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.
