Calculate remaining label lines
A 6-line label with 3 address lines and 1 program line has 2 left.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8<B8+C8 | Checks the label is too small for the required lines. | No |
| 2 | "Review label capacity …" | The message when the required lines don't fit. | Not used for row 8 |
| 3 | A8-B8-C8 | Takes both counts away from the label lines. | 2 |
| 4 | IF( … ) | Uses part 2 if the label is too small, else part 3. | 2 |
Count the lines as they really print, wrapped lines included.
=IF(A8<B8+C8,"Review label capacity below required line count",A8-B8-C8)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 labels. Paste the label's line count, the address lines and the program lines into the green columns of the Template tab. The lines left fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Lines left are room for extras only. Never drop or shorten a required line to make space.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Abbreviate one whole business word
Centerline Medical Center + Center, Ctr → Centerline Medical Ctr
Get the template →
Move the ZIP to a new line when too long
Boston MA 02108-1234 + 15 → Boston MA ¶ 02108-1234
Get the template →
Wrap a firm name at the last space
Acme Office Supply Company + 20 → Acme Office Supply ¶ Company
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →