Hi,

A lookup approach makes for a much shorter formula:

Create a range like

0 F
64 D
69 CD
74 C
79 BC
84 B
89 AB
94 A

You can adjust the first column depending on have your grades break out,
that is if your grade are things like 78.21 then you many need use 79.01 or
you may need 79.000001. Suppose the above table is in A1:C8 then the formula
would be

=LOOKUP(A18,A1:B8)

or without a lookup table:

=LOOKUP(A18,{0,"F";64,"D";69,"CD";74,"C";79,"BC";8 4,"B";89,"AB";94,"A"})

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"wtamustudentmc" wrote:

Help - nested IF statement not bringing back correct value

Cell A18=85 (result/value is SUM of other cells)
Cell
A19=IF(A1893,"A",IF(A1888,"AB",IF(A1883,"B",IF( A1878,"BC",IF(A1873,"C",IF(A1868,"CD",IF(A1863 ,"D","F")))))))

Unfortunately cell A19 is bringing back A .... not the correct value of B.
Can anyone tell me what's wrong?
--
MC