if statements

[mmode66]

The green section of my formula is counting blanks as Tier 4 and some below the mark of Tier 1 are showing Tier 4.
Can anyone see an obvious error i may be missing?

=IF(AND($D5>=$N$6,$E5>=$N$7,$F5>=$N$8,$G8>=$N$9),"Tier 4",IF(AND($D5>=$M$6,$E5>=$M$7,$F5>=$M$8,$G5>=$M$9),"Tier 3",IF(AND($D5>=$L$6,$E5>=$L$7,$F5>=$L$8,$G5>=$L$9),"Tier 2","Tier 1")))

 

[AlanY]

The green section of my formula is counting blanks as Tier 4 and some below the mark of Tier 1 are showing Tier 4.
Can anyone see an obvious error i may be missing?

=IF(AND($D5>=$N$6,$E5>=$N$7,$F5>=$N$8,$G8>=$N$9),"Tier 4",IF(AND($D5>=$M$6,$E5>=$M$7,$F5>=$M$8,$G5>=$M$9),"Tier 3",IF(AND($D5>=$L$6,$E5>=$L$7,$F5>=$L$8,$G5>=$L$9),"Tier 2","Tier 1")))

looks like that G8 may be G5

 

[mmode66]

That was it. It's still counting blanks as Tier 4 but that solved the incorrect formula issues for sure. Thank you.

 

[mmode66]

I would think since none are true it would return the "Tier 1" in the end of my formula.
Is there something about the blanks I'm not taking into account?