Forum Discussion

mahmoudmagar's avatar
mahmoudmagar
Copper Contributor
May 26, 2022

problem with if value

=IF(G22=2.142,1),IF(G22=2.68,1.2),IF(G22=3.08,1.4)    how to make this right ?
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 26, 2022

mahmoudmagar Some of the closing brackets are in the wrong place. Try this:

=IF(G22=2.142,1,IF(G22=2.68,1.2,IF(G22=3.08,1.4)))

Resources