IF AND formulas

Sarah Nielsen
Sarah Nielsen ✭✭✭
edited 05/07/21 in Formulas and Functions

I can't get the following formula to work, getting the #UNPARSEABLE error:

=IF([Regulatory Impact Score]@row >= 3.75, "High"), =IF(AND([Regulatory Impact Score]@row < 3.75, [Regulatory Impact Score]@row > 2), "Moderate"), =IF([Regulatory Impact Score]@row < 2, "Low")

If I separate these into three different formulas, they work. What am I doing wrong? I am just trying to have the formulas show a rating based on the following scale:

Rating: 3.75-5.00 = High

Rating: 2.00-3.74 = Moderate

Rating: >=1.99 = Low

Thanks in advance for any assistance.

Tags:

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Sarah,

    Try:

    =IF([Regulatory Impact Score]@row >= 3.75, "High", IF([Regulatory Impact Score]@row >=2), "Moderate", "Low"))

    Are you still getting an error?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!