I need away to deal with null values in a formula.

MJ215

I have a simple formula that gives a score a value. However I need an addition that checks to see if the cell is blank and if so this row should also be blank. My issue is the NULL is showing up as 0 and populating a "Low" rating.

Formula:

=IF([Inherent Risk Score]@row > {Key Range 3}, "High", IF([Inherent Risk Score]@row < {Key Range 4}, "Low", "Medium"))

Toufong Vang

Hi, MJ215

You're already on the track!😀 just add it to your formula... If the cell is blank, then leave blank, else apply formula.

IF( ISBLANK( [Inherent Risk Score]@row ), LEAVE_BLANK , OTHERWISE_APPLY_FORMULA )

=IF(ISBLANK([Inherent Risk Score]@row), "", IF([Inherent Risk Score]@row > {Key Range 3}, "High", IF([Inherent Risk Score]@row < {Key Range 4}, "Low", "Medium")))