Calculate a percentage-point difference
Turn a change from 10% to 15% into 5.00 percentage points.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | (B8-A8) | Takes the original rate away from the new rate. | 0.05 |
| 2 | *100 | Multiplies by 100 to make percentage points. | 5.00 |
This is the gap in points, not the percent change. A fall shows as minus, like -5.00.
=(B8-A8)*100How 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 rates. Paste original rates into column A and new rates into column B of the Template tab. The points fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Compare rates for the same group. Keep results as plain numbers: Percentage format shows 5.00 as 500.00%.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Add a percent increase to a number
100 with a 10.0% increase → 110
Get the template →
Take a percent decrease off a number
100 with a 20.0% decrease → 80
Get the template →
Undo a percent increase
110 after a 0.1 (10%) increase → 100
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →