Urgent Help please

[NS]

I am setting a following formula:

=IF(AB1>87,"A",IF(AB1>84,"B+",IF(AB1>78,"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

 

[I Stevens]

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]

I don't understand why it gives me error. Do you think it's a excel problem?

 

[Mike H]

I think posting two threads the same is a problem, check your other one!!

 

[Ron Rosenfeld]

I am setting a following formula:

=IF(AB1>87,"A",IF(AB1>84,"B+",IF(AB1>78,"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

Are you entering the 87 directly? Or is it the result of a formula?

If it is the result of a formula, then your problem is that, although you may
only be displaying 87, the "real value" is slightly larger.

One way to solve the problem is to ROUND the result of the formula you are
using.
--ron

 

[Gord Dibben]

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