I need away to deal with null values in a formula.
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"))
Answers

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")))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 465 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!