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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | ROUNDUP(number, num_digits) |
| Google Sheets | ✔ Built in | ROUNDUP(value, [places]) |
| Airtable | ✔ Built in | ROUNDUP(value, precision) |
| Notion | ≈ Workaround | sign(n) * ceil(abs(n) * 100) / 100Notion has ceil() (toward +∞) but no ROUNDUP; combine it with sign() and abs() to round away from zero. |
| Excel | =ROUNDUP(3.201, 1) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =ROUNDUP(3.201, 1) | open sheets.new ↗ |
| Airtable | ROUNDUP(3.201, 1) | |
| Notion workaround | sign(3.201) * ceil(abs(3.201) * 10) / 10 |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The value to round. |
num_digits | Decimal places to keep; negative values round to tens, hundreds and so on. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=ROUNDUP(3.201, 1) | 3.3 | Any remainder pushes the value up. | |
=ROUNDUP(-3.201, 1) | -3.3 | Away from zero, so more negative. | |
=ROUNDUP(1501, -3) | 2000 | Round up to the next thousand. | |
=ROUNDUP(A2/12, 0) | Whole boxes | E.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.