Urgent Help please

  • Thread starter Thread starter NS
  • Start date Start date
N

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 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.
 
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
Click to expand...

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
 
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
 
Back
Top