Add if Null to Formula - Parse error Malformed function

[CherylH]

This formula works:   IF [Right_Amazon Siebel Brand] THEN [Amazon Siebel Brand] ELSE [Right_Amazon Siebel Brand] ENDIF

However: Want to add if is null, but this formula does not work, balance of formula turns black.  What is wrong with formula?

IF (isnull([Right_Amazon Siebel Brand]) THEN [Amazon Siebel Brand] ELSE [Right_Amazon Siebel Brand] ENDIF

[atcodedog05 · Accepted solution]

Hi @CherylH 

Try this

IF isnull([Right_Amazon Siebel Brand]) 
THEN [Amazon Siebel Brand] 
ELSE [Right_Amazon Siebel Brand] ENDIF

There was a extra ( in your pasted formula.

[atcodedog05 · Accepted solution]

Hi @CherylH 

You can also try

IF isempty(Trim([Right_Amazon Siebel Brand]," ")) 
THEN [Amazon Siebel Brand] 
ELSE [Right_Amazon Siebel Brand] ENDIF

 So that it removes empty blanks also. 

[CherylH]

Thank you so much it worked.  What a difference a ( makes.   Knew I was close but could not get it.

[atcodedog05]

Happy to help 🙂 @CherylH 

Cheers and Happy Analyzing 😀