Rounding Rules and the Mistakes That Cost Money

Rounding looks like the least interesting thing a calculator does, right up until a spreadsheet total is a penny out and nobody can find where it went. Most of those pennies come from one of three habits.

Round once, and round from the original

Take 4.4499. Round it to two decimal places and you get 4.45. Round that result to one decimal place and you get 4.5. Round the original straight to one decimal place and you get 4.4. Same starting number, two different answers, and the second one is wrong. Rounding in stages lets a digit that should never have been promoted go on to promote the digit above it.

The fix is dull and reliable: carry full precision through every intermediate step, and round once at the end, to the precision the answer actually needs.

Not everyone rounds a half upwards

Half-up is what school taught, so 2.5 becomes 3. Half to even, often called bankers' rounding, sends 2.5 to 2 and 3.5 to 4, always landing on the even neighbour. It exists because half-up carries a bias. Feed it a thousand invoice lines that all sit exactly on half a cent and every single one rounds upward, adding around $5 across the batch. Half to even sends roughly half of them down and the total barely shifts. Python's built-in round uses half to even, while most spreadsheets round half away from zero, and that difference is usually the reason two systems disagree by a cent.

Where rounding costs real money

Sales tax is the everyday case. A $19.99 item at 8.25 percent tax is $1.649175, which becomes $1.65. Buy ten of them and there is a choice to make: tax each item and add up, giving $16.50, or tax the $199.90 basket, giving $16.49. One cent apart on a small order, repeated across a day of transactions, is exactly the sort of thing that makes a till reconciliation fail. Order of operations matters here in the same way it does when working out sales tax by hand.

Interest rates are worse, because the rounding gets compounded. A $300,000 loan over 30 years at 5.375 percent costs about $1,680 a month. Round the rate to 5.4 percent and the payment is about $1,685. The gap is $4.68 a month, which sounds like nothing until you multiply it by 360 payments and get roughly $1,685 of extra cost, all of it created by a decision in the third decimal place.

Significant figures are not decimal places

0.004823 to two decimal places is 0.00, which throws the number away entirely. To two significant figures it is 0.0048, which keeps it. Going the other way, 158,400 to two significant figures is 160,000. Decimal places are counted from the point, significant figures from the first digit that is not a zero. Lab results, engineering tolerances and anything reporting a measurement generally want significant figures.

Using the rounding calculator

Three inputs. The number itself, the place you want to round to (nearest whole, nearest ten, two decimals, or a count of significant figures), and the mode if you need something other than half-up. Ceiling always rounds up and floor always rounds down, which is what you want for ordering materials, where running short is far worse than buying one extra.

One trap on that first input: take the number from its source, not from a screen that has already rounded it for display. A spreadsheet cell showing 12.35 may be storing 12.3468, and copying what you can see bakes an error in before you begin. Click the cell and read the formula bar instead. The same discipline applies to percentage work, where a rounded input tends to get magnified rather than absorbed.

Common questions

Does 0.5 always round up? Under the school rule, yes. Under half to even, 0.5 rounds to 0 and 1.5 rounds to 2. Check which convention your software uses before reconciling a total against someone else's.

How do I round to the nearest 5 or 25? Divide, round, multiply back. For 87 to the nearest 5: 87 divided by 5 is 17.4, which rounds to 17, and 17 times 5 is 85. For the nearest 25, divide by 25 instead and follow the same three steps.

What is 2/3 to three decimal places? 0.667. The full decimal runs 0.6666, so the fourth digit is a 6 and the third rounds up from 6 to 7.

Should I round a percentage before or after multiplying? After. Rounding 8.25 percent down to 8 percent before applying it to $199.90 costs 50 cents on a single basket, and the error scales with the amount rather than staying put.