Show a credential only when verified

Pass RN through only when its status says Verified, for reviewed letters.

What you'll make

In Excel: RN + Verified becomes RN.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8="Verified"Checks if the status says Verified.Yes
2A8The credential, unchanged."RN"
3"Review verification"Shown for any other status.Not used for row 8
4IF( … )Uses part 2 if part 1 says yes, else part 3."RN"

Read it left to right. Capitals don't matter: verified counts too. The rows here are made-up.

=IF(B8="Verified",A8,"Review verification")

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 credentials. Paste each credential and its verification status into the green columns of the Template tab. The verified credentials fill in by themselves.
  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. Make sure someone really checked each credential first.

Microsoft's help: IF function