Using CONCATENATE with IF THEN?

[land3bs]

I have a spreadsheet with text, and the following columns of information:

Preferred First Name
Legal First and Last Name
Last Name

If the employee has indicated a Preferred First Name, then I want to combine that with the Last Name. If the employee has NOT indicated a preferred first name, then I want to use the Legal First and Last Name.

I'm sure there is an easy way to do this, but I am stumped!

[CAntosh]

=IF(A1="",B1&" "&C1,A1&" "&C1)

If preferred is in A1, first in B1, last in C1, place this in D1.

EDIT: Having reread your request, if preferred is in A1, first AND last are in B1, and last is in C1, then go with the following in D1:

=IF(A1="",B1,A1&" "&C1)

[loginjmor]

Hi -

Assuming the Last Name is in Cell A1, First Name in Cell B1 and Preferred First Name in Cell C1 you could put in say Cell D1 this formula:

=IF(ISBLANK(C1),B1&" "&A1,C1&" "&A1)

[land3bs]

Thank you to both! You solved it!

[loginjmor]

No problem! Thanks for the bump!