IF Statement, Both columns are blank.

[wonka1234]

hi,

Trying to create a new column if Column A is blank then use Colb to fill, else use column A. 

But what if both columns are blank? How can I add "New col is blank if both col A and B are blank"?

Here is what I got:

New col = IF ColA is "" then use ColB else use ColA.

Thanks.

[Jonathan-Sherman]

Hi @wonka1234,

You could use:

IF [ColumnA] = "" AND [ColumnB] = "" THEN ""
ELSEIF [ColumnA] = "" THEN [ColumnB]
ELSE [ColumnA]
ENDIF

Kind regards,

Jonathan