Use a secondary email if primary is blank

Use the primary address. When it is blank, the approved secondary fills in.

What you'll make

In Excel: ava@example.com or ava@example.org becomes ava@example.com.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8<>""Checks whether the primary email is filled in.Filled in
2A8The primary email, used when it's there."ava@example.com"
3IF(B8="","",B8)Otherwise the secondary email, or blank if none.Not used for row 8
4IF( … )Picks the primary email first, then the secondary."ava@example.com"

A filled-in primary email always wins and is never overwritten. Both blank gives a blank.

=IF(A8<>"",A8,IF(B8="","",B8))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own emails. Paste primary and secondary emails into the green columns of the Template tab. Leave a cell empty when there's no address.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

A cell holding only a space counts as filled in. Clear it so the secondary email is used.

Microsoft's help: IF function