BeginnerMath Functions
Round unit costs to cents with ROUND
Change a stored cost to two decimal places, not just how it is displayed.
ROUND
4 min10 points
ROUND practice exercises
Rounds a number to a set number of decimal places, changing the stored value. Below is 1 interactive exercise that puts it to work on realistic business data — you write the formula, and get told exactly what went wrong when it does not work.
Syntax
ROUND(number, num_digits)
Need a refresher? Learn ROUND — syntax, a worked example and where it goes wrong.
Practise ROUND
Ordered from most approachable to hardest.
When ROUND is the right tool
Rounds a number to a set number of decimal places, changing the stored value. It belongs to the math functions family, and it shows up constantly in real work — which is why it is worth being genuinely fluent rather than merely familiar.
Reading about a function is not the same as being able to write it. The exercises on this page exist because the gap between recognising ROUND and producing it from memory, correctly, on data you have not seen before, only closes by doing it.
Related functions
Questions about ROUND
How do I practise ROUND without Excel installed?
Every exercise on this page runs in your browser. You type the ROUND formula into a real spreadsheet grid and get told immediately whether it works — no download, no account.
What does ROUND do?
Rounds a number to a set number of decimal places, changing the stored value. The syntax is ROUND(number, num_digits). The exercises below put it to work on realistic business data rather than abstract examples.
How long does it take to learn ROUND?
Most people can write a working ROUND formula within twenty minutes of practice. Getting it right under pressure — with edge cases, unsorted data and ranges that must survive being filled down — is what the harder exercises here are for.