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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8<>"" | Checks whether the primary email is filled in. | Filled in |
| 2 | A8 | The primary email, used when it's there. | "ava@example.com" |
| 3 | IF(B8="","",B8) | Otherwise the secondary email, or blank if none. | Not used for row 8 |
| 4 | IF( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Build an email address from its two parts
ava + example.com → [email protected]
Get the template →
Format a display name and email pair
Ava Reed + [email protected] → Ava Reed <[email protected]>
Get the template →
Make a clickable email link
[email protected] + Ava Reed → Email Ava Reed (a link)
Get the template →
Check each email went to the right address, once
Your list of 2 → 2 sent copies, each to the right address
Take this route →