If statement

Occasional Visitor

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

GHughes800_1-1635318693078.png

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.