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 worki...
- 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)))
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!
