Main content
What is it?
A basis point is one hundredth of a percent. That keeps large rate values readable when the change is small compared to the headline number. Readers can scan a twenty five bps move without counting zeros in a percent string.
Because the relationship is linear, you can trust proportional reasoning. Double the bps count doubles the percent impact in the small-rate regime where the linear approximation is standard in consumer copy.
When you move from news to a spreadsheet model, remember that your sheet still stores decimals for math even when the UI prints percents or bps in commentary. That handoff is where silent bugs appear if you paste the wrong layer.
Formula
If b is a count of basis points, then percent value is p = 0.01 × b and decimal value is d = 0.0001 × b. You can also convert bps to percent first, then divide by one hundred to reach decimal form, which mirrors the core rule you use everywhere else.
If you need to sanity check a pipeline, compare your output to a trusted second source and to a known toy example such as one hundred bps equals one percent equals zero point zero one as a multiplier.
For a compact checklist of the usual spreadsheet traps, keep common conversion mistakes open while you audit cells after you convert bps.
Step-by-step guide
- Read the basis point change from the article or data feed and write the raw integer.
- Multiply by
0.01if you want a percent value for human readers. - Multiply by
0.0001if you want a plain decimal multiplier for formulas. - Compare the result against a trusted second source when the trade is live.
- Document the step you used so a teammate can reproduce your sheet without reverse engineering.
Example
Twenty five basis points equal 0.25% as a percent, which is 0.0025 as a decimal multiplier. One hundred basis points equal 1% and 0.01 as a multiplier. If either mapping surprises you, slow down and count decimal places on paper once.
If your model mixes bps input with percent-formatted cells, label intermediate columns so the next editor knows which layer is authoritative.

