SOLVED

IF Formula

Copper Contributor

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!

 

2 Replies
best response confirmed by kjb28 (Copper Contributor)
Solution
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!
1 best response

Accepted Solutions
best response confirmed by kjb28 (Copper Contributor)
Solution
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)))

View solution in original post