If Statement Plus Labels

[Alphacsulb]

Column A1 has either an E (for English) or S (for Spanish).

Column B1 has a name, for example, John Smith

In Column C1 I need a formula for the following.

If A1=E, then "Thank you B1, I enjoyed seeing you at the party. Love, Angie", if not then "Gracia B1, me gusto verte en la fiesta. Saludos, Angie"

If A1 equals E then the result should say:

Thank you John Smith, I enoyed seeing you at the party. Love, Angie.

 

[Jonmo1]

=IF(A1="E","Thank You " & B1 & ", I enjoyed....","Gracias " & B1 & ", me gusto...")

Hope that helps.

 

[hkaplan2]

Try

=if(A1="E","Thank you "&B1&", I enjoyed seeing you at the party. Love, Angie","Gracia "&B1&", me gusto verte en la fiesta. Saludos, Angie")