Formula for scores between two numbers
Hello I have been using Smartsheet for quite a while however I am really stuck on this formula. I've been searching and reading and none of the things I have found work and I'm thinking it should be this hard. I'm obviously missing something.
I have 2 columns with scores in them (that had been calculated using another field) ie if the Answer is Low the answer is 1 on the column called Score1, then if the likelihood is high the answer is 5 on the column called Score2.
A third column called Total Score is the total of Score1 multiplied by Score2 ie 2 x 6 = 12
So what I now need to do is create a formula that says if the Total Score Column is <4 answer is Low, if the score is between 4-10 answer is Moderate, if the score is between 10-15, and is High and if between 15-20 answer is Extreme.
For the life of me I cannot get this to work, can anyone assist me.
Comments
-
Hi Meredith,
You can nest IF functions. I think this will work:
=IF([Total Score]9 >= 15, "Extreme", IF([Total Score]9 >= 10, "High", IF([Total Score]9 >= 4, "Moderate", IF([Total Score]9 < 4, "Low"))))
Dave
-
Legend! Thank you it worked perfectly. I know what I was doing, I didn't have the = sign between the > sign each time.
Really appreciate your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!