problem with if value

Occasional Visitor

=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)))