Forum Discussion
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 ?
1 Reply
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)))
=IF(G22=2.142,1),IF(G22=2.68,1.2),IF(G22=3.08,1.4)
how to make this right ?
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)))
