Lesson 30 · Math & Ranking

ROUND, ROUNDUP & ROUNDDOWN

Practice ROUND, ROUNDUP and ROUNDDOWN in Google Sheets with real-world rounding problems.

Task 1 of 3

Round the unit cost in B2 to 2 decimal places. Answer in C2.

Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.

Rounding numbers properly

=ROUND(value, [places])
=ROUNDUP(value, [places])
=ROUNDDOWN(value, [places])

Formatting a cell to show 2 decimals only changes how it looks. The full value is still used in calculations. These functions change the actual value.

ROUND: normal rounding (5 and up rounds away from zero)
ROUNDUP: always away from zero. "How many boxes/tables/buses do I need?"
ROUNDDOWN: always toward zero. "How many full hours?"

places can be negative: =ROUND(1234, -2) → 1200.