IF Formula

New Contributor



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!


2 Replies
best response confirmed by kjb28 (New Contributor)
Based on Text, you can use multiple if function
Half 12 6
Onethird 12 4
Quarter 12 3

Thank you ever so much you legend!