Spreadsheet formulas explained, side by side

ROUNDUP Function in Excel, Google Sheets, Airtable & Notion

ROUNDUP rounds a number away from zero, whatever the next digit is: 3.201 rounded up to one decimal is 3.3, and −3.201 becomes −3.3.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inROUNDUP(number, num_digits)
Google Sheets✔ Built inROUNDUP(value, [places])
Airtable✔ Built inROUNDUP(value, precision)
Notion≈ Workaroundsign(n) * ceil(abs(n) * 100) / 100
Notion has ceil() (toward +∞) but no ROUNDUP; combine it with sign() and abs() to round away from zero.
Try ROUNDUP with your own values
Result (as Excel & Google Sheets return it)
3.3
Your formula, ready to paste
Excel=ROUNDUP(3.201, 1) open excel.new ↗
Google Sheets=ROUNDUP(3.201, 1) open sheets.new ↗
AirtableROUNDUP(3.201, 1)
Notion
workaround
sign(3.201) * ceil(abs(3.201) * 10) / 10

Arguments

ArgumentWhat it means
numberThe value to round.
num_digitsDecimal places to keep; negative values round to tens, hundreds and so on.

Examples

FormulaResultWhyCopy
=ROUNDUP(3.201, 1)3.3Any remainder pushes the value up.
=ROUNDUP(-3.201, 1)-3.3Away from zero, so more negative.
=ROUNDUP(1501, -3)2000Round up to the next thousand.
=ROUNDUP(A2/12, 0)Whole boxesE.g. how many boxes of 12 are needed for A2 items.

Examples use Excel / Google Sheets syntax unless noted.

How ROUNDUP works

Use ROUNDUP when partial units must be counted as whole ones: boxes to ship, people per table, billing hours, pages to print. =ROUNDUP(45/12, 0) says you need 4 boxes for 45 items, where ROUND would say 4 and INT would say 3 — and for 49 items ROUND still says 4 while ROUNDUP correctly says 5.

“Up” means away from zero, not toward positive infinity. For negative numbers ROUNDUP makes the value more negative. If you want “toward +∞” behaviour for negatives, use CEILING (or CEILING.MATH) instead. Notion's ceil() rounds toward +∞, which is why the Notion version multiplies by sign().

Frequently Asked Questions

What is the difference between ROUNDUP and CEILING?
ROUNDUP rounds to a number of decimal places, away from zero. CEILING rounds up to a multiple of any size (such as 0.05 or 15) toward positive infinity.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.