Suppress phones marked Do not use

Leave the phone blank when it's marked Do not use. Approved phones pass through.

What you'll make

In Excel: 201-555-0123 + Do not use becomes blank.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8="Do not use"Checks if the status says Do not use.Yes
2B8="Approved"Else checks if the status says Approved.Not used for row 8
3IF(A8="", … ,A8)The phone, or a Review note if it's empty.Not used for row 8
4"Review phone status"Shown for any other status.Not used for row 8
5IF( … )Blank if part 1 says yes, else parts 2 to 4.""

Read it left to right. Do not use always wins, so that phone is never shown. Capitals don't matter. The numbers here are made-up.

=IF(B8="Do not use","",IF(B8="Approved",IF(A8="","Review missing phone",A8),"Review phone status"))

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 phone and its status 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

This only reads the status column. It doesn't check consent or the rules for contacting people.

Microsoft's help: IF function