Turn basis points into a rate
Turn 125 basis points into the rate 0.0125, shown as 1.25%.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The basis points, like 125. | 125 |
| 2 | /10000 | Divides by 10000 to make a rate. | 0.0125, shown as 1.25% |
One basis point is a hundredth of a percent. The result is the number 0.0125, shown as 1.25%.
=A8/10000How 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 basis points into the green column of the Template tab. The rates fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only for basis points, like 125 for 1.25%. A percent stored as 1.25 would become 0.01%.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Turn a rate into whole basis points
1.250% → 125 basis points
Get the template →
Turn points into rates, blank if missing
-1 meaning missing → blank, not -1.0%
Get the template →
Read percent text like 12.5% as numbers
12.5% as text → 12.50% as a number
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →