Rounding With ROUND, ROUNDUP, ROUNDDOWN
Set the number of decimal places and direction of rounding.
Why Rounding Matters
Spreadsheets often produce long decimals like 3.14159 or 49.99876. For money, reports, and clean displays you usually want a tidy number such as 3.14 or 50.00.
The ROUND family of functions changes the actual stored value, not just how it looks. That is different from cell formatting, which only changes appearance. In this lesson you will meet three siblings: ROUND, ROUNDUP, and ROUNDDOWN.
The ROUND Function
ROUND takes two arguments: the number to round and how many decimal places to keep.
- number the value or cell reference
- num_digits how many decimals to keep
It rounds to the nearest value, using the standard rule: 5 and above rounds up, below 5 rounds down. Here we round a price to 2 decimal places.
=ROUND(49.99876, 2)All lessons in this course
- Rounding With ROUND, ROUNDUP, ROUNDDOWN
- Truncating With INT and TRUNC
- Rounding to Multiples With MROUND
- Formatting Numbers as Text With TEXT