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?
Best Answers

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 Happy to help!
Answers

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

Yes, this worked out perfectly! thanks so much!

@AmyD Happy to help!
Help Article Resources
Categories
Check out the Formula Handbook template!