Oct 11 2022 09:23 PM
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!
Oct 11 2022 11:09 PM
SolutionOct 11 2022 11:09 PM
Solution