What's wrong with my formula

[whoistherealmonkey]

Hi there,

I'm stumped as to why my formula doesn't work, please help this technotard..

=IF(F9>150,"Poor",IF(AND(F9<150,>111,"Below Average",IF(F9<110,>91,"Average",IF(F9<90,>81,"Good",IF(F9<80,"Excellent")))))

 

[Jonmo1]

Welcome to the board.

Try
=LOOKUP(F9,{0,80,90,110,150},{"Excellent","Good","Average","Below Average","Poor"})

 

[whoistherealmonkey]

Welcome to the board.

Try
=LOOKUP(F9,{0,80,90,110,150},{"Excellent","Good","Average","Below Average","Poor"})

Legend!! thank you

 

[Jonmo1]

You’re welcome

 

[Drrellik]

Nice. saving this for later...

 

[whoistherealmonkey]

OK Next hair removal problem

=IF(G4=Male,AND(G3>=45,"1",""),IF(G4=Female,AND(G3>=55,"1","")

What am I missing? Or should I use the look up formula again?