I am trying to create a logical function in excel for the following conditions.
if value > 85 then the output should be 2
else if value < 85 the output should be 1
else
value < 65 the output should be 0
The formula I have created has the following syntax:
=IF(O25>85;"2";IF(O25<85;"1";IF(O25<65;"0")))
But the output for when its less then 65 fails. What have i missed here?
Brgds, Sohail
Aucun commentaire:
Enregistrer un commentaire