If statement

[GHughes800]

Hello all, I'm having trouble with an IF statement formula

The code I am using is;

=IF(AI7>=90,"A",IF(AI7<=80,"B",IF(AI7<=70,"C",IF(AI7<=60,"D",IF(AI7<=59,"E",IF(A17=0," "))))))

I need the overall score to display the conditioning formatting based on the 'Total Points Earned' percentage.

Please advise.

Thank you.

[#2]

@GHughes800 I believe you need to change the <= to >= in the nested IF's. As you have it now, AI7 = 0 which is less then 80, so the formula returns B and stops.