Urgent - Setting up a formula

  • 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
 
Probably your AB list is text. You can check with the ISTEXT() function.
Copy an empty cell.
Select your AB column data
Edit>Paste special, check Add
Ok now?
 
You have responses at your other post, too.
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...
 
Back
Top