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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8*10000 | Multiplies the rate by 10,000 to get basis points. | 125 |
| 2 | 0 | Asks for no decimals. | 0 |
| 3 | ROUND( … ) | Rounds to the nearest whole basis point. | 125 |
One basis point is 0.01%, so 1% is 100 basis points. Halfway values round away from zero.
=ROUND(A8*10000,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 rates into the green column of the Template tab. The basis points 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 when whole basis points are wanted. 2.346% becomes 235, so the 0.4 is lost.
Microsoft's help: ROUND function
OTHER ROUTES YOU MIGHT LIKE

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 →
Read percent text like 12,5% as rates
12,5% as text → 0.125
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →