lundi 2 mars 2015

Excel IF statement

I think my logic is wrong?, please help.


Score Grade 80 A+, 70 A, 50 C, 40 F, 0-39 FAIL


=IF(B26=79,"A+",IF(B26>=69,"A",IF(B26>=49,"C",IF(B26=40,"A","F"))))


Aucun commentaire:

Enregistrer un commentaire