Simple IF Formula to Ignore Blanks

[Gtrtim112]

I don't think a work book upload is necessary for this question. I'm sure someone knows the answer pretty quickly.

I can't figure out how to make the following formula ignore blanks. Column A is someone's first name and column B is the second name. Column C would automatically populate with: [email protected]. Currently if column A and B are blank, I get: [email protected]

I just want it to be blank if there are no names listed in column A or B

Current Code:

Please Login or Register  to view this content.

Can someone help me solve this one? Again... I'm sure it's probably an easy one. It's eluding me, though.

[Sam Capricci]

try...
=IF(AND(A10="",B10=""),"",A10&"."&B10&"@gmail.com")

[Gtrtim112]

try...
=IF(AND(A10="",B10=""),"",A10&"."&B10&"@gmail.com")

Perfect... thank you! I knew I wasn't holding my tongue right... haha.

[Sam Capricci]

You're welcome. And thank you for the rep!