# Formula for scores between two numbers

edited 12/09/19

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.

Tags:

• 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!