7 Replies Latest reply on Sep 2, 2014 11:07 AM by raybaudi

    Multi-step calculation


      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.