Wauvel

Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All functions

ROUND / ROUNDUP / ROUNDDOWN

Math & rounding

Round a number to a set number of digits — control the pennies before they compound.

Difficulty

Beginner
Excel file

1What is it?

ROUND rounds a number to a given number of digits (5 rounds up); ROUNDUP always rounds away from zero and ROUNDDOWN always toward it. The num_digits argument is the key: a positive value rounds to decimal places, 0 to whole numbers, and a negative value to tens, hundreds, or thousands. This is real rounding that changes the stored value — unlike cell formatting, which only changes what you see while the full precision still adds up underneath.

2What it looks like

ROUND(number, num_digits)
number
The value to round.
num_digits
Places to keep: 2 = cents, 0 = whole number, -3 = nearest thousand.

3When you use it

  • Round a calculated price or rate to the cent so a column actually foots.
  • Round figures to the nearest thousand for a clean summary (num_digits -3).
  • Force rounding up with ROUNDUP — e.g. units, licenses, or headcount you can't buy a fraction of.

4See it in action

Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.

Start simple · 1 of 2

Round the number in B2 to a set number of digits. This changes the value, not just the display.

C2
fx
=ROUND(B2, 2)1,234.57
ABC
1FieldValueResult
2Raw number1,234.57

The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.

5Common errors

#VALUE!number isn't numeric (it's text).

Fix: Make sure the input is a real number — VALUE() or clean it upstream.

Still looks longYou formatted the cell instead of rounding it.

Fix: Formatting only hides digits; use ROUND to change the stored value so totals tie.

Rounds the wrong wayYou wanted always-up or always-down.

Fix: Use ROUNDUP or ROUNDDOWN instead of plain ROUND.

6Better functions & alternatives

  • MROUND — Round to the nearest multiple — e.g. the nearest 0.05 or 25.
  • CEILING / FLOOR — Round up/down to a multiple (pricing tiers, case packs).
  • INT / TRUNC — Drop the decimals entirely — TRUNC doesn't round, INT floors.

Want ROUND / ROUNDUP / ROUNDDOWN already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.

Learn the moves here — or let Wauvel run them on your numbers.

Get my free report →