How to concatenante a Value_If_True in an IF statement

[airca101]

If I2 is not equal to VACANT, I want to concatenate I2 (first name) and H2 (last name), if it is equal, I want it to read VACANT.

My poor attempt: =IF(I2<>"Vacant",(CONCATENATE(I2,H2)),"Vacant")

Any help would be lovely for this newbie of complicated (to me) formulas.

 

[Jonmo1]

Welcome to the board.

That formula looks fine..and works for me
In what way does it not work for you?

 

[airca101]

Hmm...I enter the formula and it looks fine, but I hit enter, and the formula still shows instead of what should have been returned. Not even an error, the entire forumla as written still shows in the cell.

 

[Jonmo1]

Format the cell you're putting the formula into as General
then RE-Enter the formula

 

[airca101]

Thank you so much!!! I figured it might not be seeing it as a formula. Fast help, I really appreciate it.