Write a part of a total as a percent
Turn 1 out of 4 into 25.0%, and flag a total of 0.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8=0 | Checks if the total is 0. | No |
| 2 | "Review zero total" | What the cell says when it is 0. | Not used for row 8 |
| 3 | TEXT(A8/B8, … ) | Divides count by total, written with one decimal. | "25.0%" |
| 4 | IF( … ) | Uses part 2 for a 0 total, otherwise part 3. | "25.0%" |
A total of 0 has no percent, so the row asks for a look instead of showing a false 0.0%.
=IF(B8=0,"Review zero total",TEXT(A8/B8,"0.0%"))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 numbers. Paste counts into column A and totals into column B of the Template tab. The percents fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check that each count is part of its total. A count above its total, like 5 of 4, gives 125.0%.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Write a label like +5.0 percentage points
0.05 → +5.0 percentage points
Get the template →
Write a signed percent like +12.5%
0.125 → +12.5%
Get the template →
Write percentage points as percent text
12.5 as points → 12.5% as text
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →