The ROUND function
Rounding for real, not just on display: an amount to the cent, an average to the whole number, a price to the ten.
Syntax
=ROUND(number, num_digits)
In a French Excel: =ARRONDI(nombre; no_chiffres).
Arguments
- number: the value to round.
- num_digits: 2 for cents, 0 for the whole number, -1 for the ten, -2 for the hundred.
An example
=ROUND(B2*1.2,2)
The price including tax, to the cent.
Pitfalls
- The display format does not round: a cell showing 10.33 may hold 10.3333; totals do not add up.
- ROUNDUP and ROUNDDOWN always round up or down.
Going further
- Find the right formula: "round a number".
Frequently asked questions
- Why does my total not add up?
- The cells show rounded values, but the total adds up the full values. Round with ROUND in each row.