Turn a rate into whole basis points

Turn 1.25%, stored as 0.0125, into 125 basis points.

What you'll make

In Excel: 1.250% becomes 125 basis points.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8*10000Multiplies the rate by 10,000 to get basis points.125
20Asks for no decimals.0
3ROUND( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own numbers. Paste rates into the green column of the Template tab. The basis points fill in by themselves.
  3. 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