IF AND formulas
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.
Best 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
-
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","")))
-
Thanks for the quick response, but that didn't work. What are the double quotations for at the end?
-
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.
-
Mark: Thanks! Deleting the equal signs fixed the problem!
Sarah
-
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
Categories
Check out the Formula Handbook template!