Formula to return a blank cell if columns are blank

Hello,

I am working on a formula that will return me the following:

If equal to or less than 4 = Low
If equal to or less than 7 = Modest
If equal or less than 11 = Moderate
If Greater than 12 = High

=IFERROR(IF([Risk Score (calculated)]@row <= 4, "Low", IF([Risk Score (calculated)]@row <= 7, "Modest", IF([Risk Score (calculated)]@row <= 11, "Moderate", IF([Risk Score (calculated)]@row >= 12, "High")))), "")

I would like it to not have a value in the Risk Severity column if the Risk Score is Blank. Currently if the cell is blank, it is showing me "Low" as the value in the Risk Severity.

Any recommendations?

Find more posts tagged with

Accepted answers

Heather Duff

Hi @AmyD ,

Try this:

=IFERROR(IF(ISBLANK([Risk Score (calculated)]@row), "", IF([Risk Score (calculated)]@row <= 4, "Low", IF([Risk Score (calculated)]@row <= 7, "Modest", IF([Risk Score (calculated)]@row <= 11, "Moderate", IF([Risk Score (calculated)]@row >= 12, "High", ""))))),"")

Let me know if it works for you!

Best,

Heather

Heather Duff

@AmyD Happy to help!

All comments

Heather Duff

Hi @AmyD ,

Try this:

Let me know if it works for you!

Best,

Heather

AmyD

Yes, this worked out perfectly! thanks so much!

Heather Duff

@AmyD Happy to help!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.