Write a benefit caption with full scope
Keep network, individual or family, and term with each benefit label.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | OR(A8="",B8="",C8="",D8="") | Checks if any of the four labels is empty. | No |
| 2 | A8&" ("&B8&"; "&C8&"; "&D8&")" | Puts the three labels in brackets after the benefit. | "Labs (In; …)" |
| 3 | IF( … ) | Flags a row with a missing label, else uses part 2. | "Labs (In; …)" |
Review missing benefit scope shows when part 1 says yes.
=IF(OR(A8="",B8="",C8="",D8=""),"Review missing benefit scope",A8&" ("&B8&"; "&C8&"; "&D8&")")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 list. Paste each benefit and its network, individual or family, and term labels into the green columns of the Template tab. The captions fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use labels that belong to the same benefit. Don't fill a gap with a guess, since the caption would look certain.
Microsoft's help: Using IF with AND, OR and NOT
OTHER ROUTES YOU MIGHT LIKE

Count visits left without hiding overuse
20 allowed, 6 used → 14 left
Get the template →
Find benefit money left in one currency
500.00 USD allowed, 125.50 USD used → 374.50 left
Get the template →
Show a count, money or text allowance
Money, 1500, USD → USD 1500.00
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →