combining two cells which contain text

[JK Brooks]

Hello,

I have a spreadsheet with first and last name columns. I'd like to
combine them so that the resulting 3rd cell is (e-mail address removed)

My first order of business is to test that I don't already have an
email address. This is as far as I've gotten.

A = first
B = last
C = email

in column D
=if(c1>0,c1, . . .

I don't know what to do next. Can you help?
thanks

 

[J.E. McGimpsey]

Hello,

I have a spreadsheet with first and last name columns. I'd like to
combine them so that the resulting 3rd cell is (e-mail address removed)

My first order of business is to test that I don't already have an
email address. This is as far as I've gotten.

A = first
B = last
C = email

in column D
=if(c1>0,c1, . . .

I don't know what to do next. Can you help?
thanks

One way:

D1: =IF(C1<>"",C1, A1 & "." & B1 & "@company.com")