IF formula issue

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

Capture 1.JPG

Find more posts tagged with

Formulas

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…