Formula to return a blank cell if columns are blank

AmyD

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?

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!

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

AmyD

Yes, this worked out perfectly! thanks so much!

Heather Duff

@AmyD Happy to help!