Calculate remaining label lines

A 6-line label with 3 address lines and 1 program line has 2 left.

What you'll make

In Excel: 6-line label, 3 address + 1 program becomes 2 lines left.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8<B8+C8Checks 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
3A8-B8-C8Takes both counts away from the label lines.2
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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