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.

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.