I pasted the formula into A19, entered 85 in A18 and got the result B in A19,
as expected..

I think you have a text value in A18
Test with
=ISNUMBER(A18) in any cell

If you get FALSE then that is your problem...

Format the cell as Number... enter 85 again and your formula will work...
--
--------
If this is what you wanted then press the ''''YES'''' button (if you see it)


"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