Oct 27 2021 12:14 AM
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.
Oct 27 2021 12:37 AM
@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.