Forum Discussion
Solved
IF Formula
Hi!
I have set up an IF function with a helper cell. The formula is =IF(C4="Half",L4,E4) and the helper is =E4/2
If I type "Half" in C4 it will halve the number I enter in E4 which is working perfectly.
HOWEVER is it possible to have more than one IF so that I can divide the number by 2 or 3 or 4 etc.?
OR is there another formula I can use?
Thank you!
- Based on Text, you can use multiple if function
Half 12 6
Onethird 12 4
Quarter 12 3
=IF(A1="Half",C1/2,IF(A1="Onethird",C1/3,IF(A1="Quarter",C1/4,E1)))
- Based on Text, you can use multiple if function
Half 12 6
Onethird 12 4
Quarter 12 3
=IF(A1="Half",C1/2,IF(A1="Onethird",C1/3,IF(A1="Quarter",C1/4,E1)))- Thank you ever so much you legend!
