samedi 19 novembre 2016

incapsulated if functions in excel formulas now working

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