I copied your formula to test it and it's providing the correct answers when
I tried it. I even tried your example of entering the grade of 87 and it
gave me the result of B+. I don't understand as to why you would be
receiving the incorrect result.

"NS" wrote:

I am setting a following formula:

=IF(AB187,"A",IF(AB184,"B+",IF(AB178,"B",IF(AB1 72,"C",IF(AB1<73,"F",0)))))

for grades of student.

It gives me error. For example. If student got 87 he should have B+
according to formula. However, excel gives me "A" instead of B+.

Please help