Excel exercises
Excel exercises: Rounding money
Rounding to two decimals on screen and rounding the stored number are different operations, and money cares about the difference.
ROUND changes the value: 4450.3992 becomes 4450.4 in the cell, while a cell format only changes what you see. ROUNDUP and ROUNDDOWN move a price in one direction only. MROUND and FLOOR round to a multiple, so 47 can land on 45 or 50, and a pack of six ships 42 rather than a part-filled 48.
Three exercises, all at level 2. Each prompt names the rule and the unit, because nearest and up to the nearest produce different answers down a column.
The test worth running after each one is a sum of the rounded column against the rounded sum of the column. When the two totals disagree, a format is standing in for a calculation. That gap is exactly what a reconciliation at work looks for. On the markup exercise, 4450.3992 is rounded once, at the end, to 4450.4.
A stale exercise is one you finished two weeks ago or longer. One that needs practice took a hint, or more than one try.
0 of 3 complete
- ROUND: money to two decimals Round a marked-up total once, and know that the stored value changed.
- ROUNDUP and ROUNDDOWN: one direction only Paid Choose the direction on purpose, so the count follows the job.
- MROUND and FLOOR: round to a multiple Paid Round to a pack size or a price step instead of to a number of decimals.