When using the IF/AND function I am recieveing a #UNPARSEABLE error

Question

I am trying to return an Excellent, Good, Fair, Poor, Dire rating based on a score range. Below is the formula I am trying to use.

=IF([Total Score]@row ≥ 10, "Dire", IF(AND([Total Score]@row ≥ 7, [Total Score]@row ≤ 9, "Poor", IF(AND([Total Score]@row ≥ 4, [Total Score]@row ≤ 6, "Fair", IF(AND([Total Score]@row ≥ 1, [Total Score]@row ≤ 3, "Good", IF(AND([Total Score]@row = 0, "Excellent")))))))))

Matt1175 · Answer

Fantastic. This is perfect.

Steve Rohrdanz · Answer

Try this: =IF([Total Score]@row >= 10, "Dire", IF(AND([Total Score]@row >= 7, [Total Score]@row <= 9), "Poor", IF(AND([Total Score]@row >= 4, [Total Score]@row <= 6), "Fair", IF(AND([Total Score]@row >= 1, [Total Score]@row <= 3), "Good", IF([Total Score]@row = 0, "Excellent")))))