Rounding With ROUND, ROUNDUP, ROUNDDOWN

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.

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.

The formula =ROUND(49.99876, 2) looks at the third decimal (8). Because it is 5 or more, the second decimal rounds up, giving 50.00.

Compare with =ROUND(3.14159, 2). The third decimal is 1, which is below 5, so nothing rounds up and you get 3.14. The function always keeps exactly the number of decimals you asked for.

Use 0 for num_digits to round to the nearest whole number. This is handy for headcounts, quantities, or any value that should not have decimals.

For example =ROUND(87.6, 0) returns 88, while =ROUND(87.4, 0) returns 87. The decimal part decides the direction.

A negative num_digits rounds to tens, hundreds, or thousands. This is great for rough summaries.

• -1 rounds to the nearest ten
• -2 rounds to the nearest hundred
• -3 rounds to the nearest thousand

So =ROUND(1287, -2) returns 1300, because 1287 is closer to 1300 than to 1200.

ROUNDUP uses the same two arguments but always rounds away from zero, no matter how small the dropped digits are.

For instance =ROUNDUP(2.001, 2) still gives 2.01, even though 1 would normally round down. Use ROUNDUP when you must never undercharge or undercount, such as billing partial usage as a full unit.

Imagine you charge per box and each box holds 12 items. A customer orders 37 items. Dividing gives 37/12 = 3.083 boxes, but you cannot ship a partial box.

Wrapping it in ROUNDUP with 0 decimals forces the value up to the next whole box: 4. ROUNDUP guarantees you never round below what is actually needed.

ROUNDDOWN always rounds toward zero, dropping the extra digits without ever rounding up.

So =ROUNDDOWN(2.999, 2) returns 2.99, and =ROUNDDOWN(2.999, 0) returns 2. This is useful when you want a conservative figure, such as how many full items fit in a budget.

Take the value 4.567 rounded to 1 decimal place by each function:

• ROUND(4.567, 1) gives 4.6 (nearest)
• ROUNDUP(4.567, 1) gives 4.6 (away from zero)
• ROUNDDOWN(4.567, 1) gives 4.5 (toward zero)

Here ROUND and ROUNDUP happen to match because the second decimal is 6. With 4.541, ROUND and ROUNDDOWN would both give 4.5 instead.

In real worksheets you round values that live in cells, not literal numbers. If a calculated tax sits in B2, you can round it inline.

The formula below rounds the tax in B2 to the nearest cent. When B2 changes, the rounded result updates automatically. This keeps stored money values clean for further math.

One key point: cell number formatting only changes how a value looks. The underlying number stays long, so later sums can drift by a cent.

ROUND changes the value itself, so totals stay exact. Rule of thumb: format for display, but use ROUND when the rounded number will be used in more calculations, especially with money.

Test your understanding of the ROUND family.

You now control rounding precisely:

• ROUND(number, digits) rounds to the nearest value (5 and up goes up).
• ROUNDUP always rounds away from zero.
• ROUNDDOWN always rounds toward zero.
• Positive digits keep decimals; 0 gives whole numbers; negatives round to tens, hundreds, and beyond.

Use these functions, not just formatting, whenever the rounded value feeds further math.