If statement

Occasional Visitor

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.


1 Reply

@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.