IF AND Statement

[shatan]

Hi All, i got brain freeze this morning,
im trying to wright an argument, where if the value is less than 309 answer is poor,
between 309 to 462 it is Average and between 462 and 616 Good and above 616 is excellent,
now i also need to add the 309 to the "poor" and Good to 462 and Average to the 616, but this is what i have wrote and it doesn't like it.
=IF(C604<309,"POOR",IF(AND(C604>309=TRUE,<462=TRUE,"AVERAGE",IF(AND(C604>462=TRUE, <616=TRUE,"GOOD",IF(C604>616,"EXCELLENT"))))))
i know this is a simple request and i should know it by now, sorry to be a pain.

 

[shatan]

Hi All, i got brain freeze this morning,
im trying to wright an argument, where if the value is less than 309 answer is poor,
between 309 to 462 it is Average and between 462 and 616 Good and above 616 is excellent,
now i also need to add the 309 to the "poor" and Good to 462 and Average to the 616, but this is what i have wrote and it doesn't like it.
=IF(C604<309,"POOR",IF(AND(C604>309=TRUE,<462=TRUE,"AVERAGE",IF(AND(C604>462=TRUE, <616=TRUE,"GOOD",IF(C604>616,"EXCELLENT"))))))
i know this is a simple request and i should know it by now, sorry to be a pain.

cracked it
=IF(AND(C604<=309),"POOR",IF(AND(C604>309,C604<=462),"AVERAGE",IF(AND(C604>462,C604<=610),"GOOD",IF(AND(C604>616),"EXCELLENT"))))