Forum Discussion
If function or equivalent
Cell C2 will contain one of 1/2/3. If C2=1, G2 has to calculate E2*7.0 If C2=2, G2 has to calculate E2*6.5 If C2=1, G2 has to calculate E2*6
Hello Yugandhar__Y,
I assume your last IF() statement means to read "If C2=3, G2 has to calculate E2*6". If so then use the following formula:
=IF(C2=1,E2*7,IF(C2=2,E2*6.5,IF(C2=3,E2*6,"Please select an integer between 1 and 3")))
Thankyou very much for the support. It saves a lot of confusion for me.
- My Pleasure!