Are you sure 87 is 87 and not a calculated value like 87.000000123 just
displaying as 87?

Have you tried deleting the contents then typing 87 in the cell?


Gord Dibben MS Excel MVP

On Thu, 22 Oct 2009 10:54:01 -0700, NS wrote:

I am setting a following formula:

=IF(AB187,"A",IF(AB184,"B+",IF(AB178,"B",IF(AB 172,"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