AnsweredAssumed Answered

Salutation formula

Question asked by MorganPursley on Feb 9, 2012
Latest reply on Feb 10, 2012 by MorganPursley

Title

Salutation formula

Post

I'm trying to create a formula that will display the full salutation based on other fields (First Name, Last Name, Title, Spouse Name, etc). I thought a nested IF statement would do the trick, and maybe I just missed something, but that generated a big fat ?

Here's what I'm trying to accomplish.

If the spouses last names are different, the result should be <Title> <First_Name> <Last_Name> "&" <Title1> <Spouse_Name> <Spouse_Last_Name>  (Dr. John Smith & Dr. Jane Doe)

If they are the same, or there is a Spouse first name and no last name, the result should be <Title> <First_Name> "&" <Soupse_Name> <Last_Name>  (Dr. John & Jane Smith)

If there is no spouse information, the result should be <Title> <First_Name> <Last Name>  (Dr. John Smith)

 

The current formula is  Evaluate ( "Name_First & \" \" & Name_Last" ; [Name_First ; Name_Last] )  and I tried altering that to fit, but that didn't quite work either.

Any suggestions? Thanks!

Outcomes