Add if Null to Formula - Parse error Malformed function

Question

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 Answer

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 Answer

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.