Using IF function in concatenation formula

I would like to embed an IF statement in a concatenation like “IF {column1} is empty, show {column1}” AS IN:
concatenate ({column1}," “,IF {column1} is empty, show {column2},” ",{column3})

Is this possible?

Yes, you can do this, but there is not “empty” function so if you are using text functions you can do…

CONCATENATE ({column1},IF(LEN({column1})>0," “,”“),{column2},IF(LEN({column2})>0,” “,”“),{column3},IF(LEN({column3})>0,” “,”")

or TRIM(CONCATENATE({column1}," “,{column2},” ",{column3}))

Hope this helps

Matthew

1 Like