Forum Discussion
Yugandhar__Y
Nov 02, 2019Copper Contributor
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
6 Replies
Sort By
- SergeiBaklanDiamond Contributor
- Detlef_LewinSilver Contributor
- Yugandhar__YCopper Contributor
Detlef_LewinThankyou very much
- PReaganBronze Contributor
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")))
- Yugandhar__YCopper Contributor
Thankyou very much for the support. It saves a lot of confusion for me.
- PReaganBronze ContributorMy Pleasure!