Nested If statement not working

[hornet7]

OK...here is what I have:

example.png

The formula I used is:

=IF(AO11<=.5999,F,IF(AND(AO11>.5999,AO11<=.6999),D,IF(AND(AO11>.6999,AO11<=.7999),C,IF(AND(AO11>.7999,AO11<=.8999),B,IF(AND(AO11>.8999,AO11<=1.000),A)))))

I am trying to attach a letter grade to a percentage (A = 100-90, B = 89.99-80, C = 79.99-70, D = 69.99-60, F = 59.99-0)

It tells me there is an error and highlights the "C" but I don't understand why it is an error.

[martindwilson]

text needs to be in quotes "c"

=IF(AO11<=0.5999,"F",IF(AND(AO11>0.5999,AO11<=0.6999),"D",IF(AND(AO11>0.6999,AO11<=0.7999),"C",IF(AND(AO11>0.7999,AO11<=0.8999),"B",IF(AND(AO11>0.8999,AO11<=1),"A")))))

Youcould also use
=IF(AO11="","",LOOKUP(A011*100,{0,60,70,80,90},{"F","D","C","B","A"}))
or
=IF(AO11="","",LOOKUP(A011,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"}))

[hornet7]

Wow...I feel stupid now...I knew that and just missed it.

Thanks!

[FDibbins]

You might also consider using a small table and a vlookup instead of the nested IF()'s