IF formula issue

Faz Mussa

The formula I've created isn't working correctly and I can't figure out what I'm doing wrong. 

=IF([New NCN Score Total]120 = 15, IF([New NCN Score Total]120 <= 14, IF([New NCN Score Total]120 <= 9, IF([New NCN Score Total]120 <= 6, "Very Good"), "Good"), "Poor"), "Very Poor")

Scores

15 = Very Good

10 to 14 = Good

7 to 9 = Poor

(-)6 to 6 = Very Poor

 

Currently, when 15 is entered, it shows Poor which is not right at all. Can anyone help?

Thanks

Faz

 

Dan Seidler

Try this

=IF([New NCN Score Total]@row >= 15, "Very Good", IF([New NCN Score Total]@row >= 10, "Good", IF([New NCN Score Total]@row >= 7, "Poor", IF([New NCN Score Total]@row < 7, "Very Poor"))))

When building a nested IF statement, you want it to return the string (Very Good) if it meets the logical expression.  So, if 15 is >= 15, say "Very Good".  If it does not, try the next logical expression, etc.

Faz Mussa

That worked perfectly. Awesome, thanks so much.