Pick the Mobile or Office phone

Use the phone each person prefers, Mobile or Office. A missing one is flagged.

What you'll make

In Excel: Mobile, 201-555-0123, 617-555-0142 becomes 201-555-0123.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8="Mobile"Checks whether the person prefers Mobile.Yes
2IF(B8="", … ,B8)The mobile phone, or a Review note if it's empty."201-555-0123"
3IF(A8="Office", … )Else the office phone, or a Review note.Not used for row 8
4IF( … )Uses part 2 if part 1 says yes, else part 3."201-555-0123"

Read it left to right. Any other preference word gets a Review note, never a guess. Capitals don't matter. The numbers here are made-up.

=IF(A8="Mobile",IF(B8="","Review missing mobile",B8),IF(A8="Office",IF(C8="","Review missing office",C8),"Review phone preference"))

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 numbers. Paste each preference, Mobile or Office, and both phones into the green columns of the Template tab. The phone to use fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Spell the preference exactly Mobile or Office. Cell, Work or a stray space gets a Review note.

Microsoft's help: IF function