AnsweredAssumed Answered

Multi-step calculation

Question asked by denversusan2 on Aug 31, 2014
Latest reply on Sep 2, 2014 by raybaudi

I have two fields of data that I want to use to populate third field. Field #1 contains a Joint Saluation (Mr. & Mrs.), Field #2 contains single salutation (Ms.). All #2 fields have data, some of the #1 fields are empty because not everyone has a joint salutation.

 

How do I write a calculation for a third field to copy info from column 1, but if #1 field is empty then it needs to take the info from #2 field.

Outcomes