IF AND formulas

Sarah Nielsen

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.

Mark Cronk

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

Heather Duff

Hi @Sarah Nielsen

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

Sarah Nielsen

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

Mark Cronk

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

Sarah Nielsen

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

Sarah

Mark Cronk

Excellent. Thank you for contributing to the Community.

Mark