Use a different value for Null Statement

[has3240]

Hello Everyone,

In my script, I am using the following if Statment, and it works fine. What I am struggling is with when there is a null value.

if(Category = 'Maintenance', "Description of Damage") No issue at all.

However, if Category = 'Maintenance' has a null value I want to use "Describe the incident" as a then statement. 

This is the function I tried to used and it not working

if(IsNull(Category = 'Maintenance'), "Describe the incident",  "Description of Damage"))

Please let me know what I am doing wrong.

Thanks in advance. 

[brunobertels]

may be this :

if(IsNull(Category), "Describe the incident",  if(Category = 'Maintenance', "Description of Damage"))

[has3240]

Hey Bruno,

Thanks for your prompt reply. I tried and it's not working. 

[brunobertels]

Hi 

when you write " Category = 'Maintenance' has a null value" do you mean the cell is blank ? 

may be 

if(len(trim(Category))=0,'Describe the incident', if(Category = 'Maintenance','Description of Damage'))

regards 

[has3240]

when you write " Category = 'Maintenance' has a null value" do you mean the cell is blank?. No just some of the value is blank. In all the blank values thats where I want to use "Describe the incident"