Can someone help me with the IF/THEN formula?
I have a sheet that has a column with a total score. If the score is between the ranges below I want a new column to reflect the label of met, partially met or did not meet.
Scoring Ranges and Criteria
301-500 = Met
101-300 = Partially Met
less than 100 = Did Not Meet
Answers
-
This is my understanding. The score is one column and the criteria you want to return is a seperate column. If this correct try the formula below
=IF(Score@row > 300, "Met", IF(Score@row > 100, "partially met", IF(Score@row > 1, "Did Not Meet")))
________________________________________________________________________________________________________________________
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Meg Young mmyoungconsulting@gmail.com. Certified in Core Product, Project Management, and System Administration
-
Hi Meg - thank you for this help. I entered the formula and am getting the below message. I'm not good with formulas at all so I'm sure it's me.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!