# IF AND formulas

Options
edited 05/07/21

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:

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

Try this:

=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","")))

• Options

Thanks for the quick response, but that didn't work. What are the double quotations for at the end?

• ✭✭✭✭✭✭
Options

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.

• Options

Mark: Thanks! Deleting the equal signs fixed the problem!

Sarah

• ✭✭✭✭✭✭
Options

Excellent. Thank you for contributing to the Community.

Mark

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!