Formula for IF

Question

Hi,

I would like to do a formula where if column Country 1 is "Hong", then "Country 1 + Country 2 + Country 3"

Country 1Country 2Country 3Cambodia  HongKong HongKongRO

End result would be as below;

Country 1CambodiaHong KongHong Kong RO

Appreciate some guidance on using formula.

Thanks in advance.

ShankerV · Accepted Answer

Hi @JingYih_Herbalife

IF [Country 1] = "Hong"

THEN [Country 1]+[Country 2]+[Country 3]
ELSE [Country 1]
ENDIF

Many thanks

Shanker V

caltang · Accepted Answer

Let me add on to @ShankerV 's quick one to account for trailing whitespace:

IF [Country 1] = "Hong"

THEN [Country 1]+[Country 2]+
 (IF IsEmpty([Country 3]) 
 THEN NULL()
 ELSE [Country 3]
 ENDIF)

ELSE [Country 1]

ENDIF

Otherwise, you can use Shanker's formula provided your data cells are not empty - make them Null() to be sure to avoid trailing whitespace OR you can use a Data Cleanse tool thereafter the formula to clear whitespace as well.

Hope this helps!

-Cal