Write a label like +5.0 percentage points
Turn a rate difference of 0.05 into +5.0 percentage points.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8*100 | Turns the rate difference into points. | 5 |
| 2 | "+0.0;-0.0;0.0" | The pattern: a + or - sign and one decimal. | "+0.0;-0.0;0.0" |
| 3 | TEXT( … ) | Writes the points as text in that pattern. | "+5.0" |
| 4 | &" percentage points" | Adds the words percentage points. | "+5.0 … points" |
A difference of exactly 0 gets no sign: 0.0 percentage points. The number in the cell doesn't change.
=TEXT(A8*100,"+0.0;-0.0;0.0")&" percentage points"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 rate differences into the green column of the Template tab. The labels fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this for the gap between two rates. A rise from 0.1 to 0.15 is +5.0 points, not a 50% change.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

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 →
Write a percent with chosen decimals
0.125, 1 decimal → 12.5%
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →