Math & Trig
All versions
◉ 33 views
=ROUNDUP()
Rounds a number up, away from 0 (zero).
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=ROUNDUP(number, num_digits)
Hover argument names in the table for details.
Output typeNumber
Popularity60 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =ROUNDUP() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Required | Any real number that you want rounded up. |
num_digits |
Number | Required | The number of digits to which you want to round number. |
▣ Examples
Rounds 3.2 up to zero decimal places.
=ROUNDUP(3.2,0)
Result:
4
Rounds 76.9 up to zero decimal places.
=ROUNDUP(76.9,0)
Result:
77
Rounds 3.14159 up to three decimal places.
=ROUNDUP(3.14159, 3)
Result:
3.142
Rounds -3.14159 up to one decimal place.
=ROUNDUP(-3.14159, 1)
Result:
-3.2
Rounds 31415.92654 up to 2 decimal places to the left of the decimal point.
=ROUNDUP(31415.92654, -2)
Result:
31500
§ Remarks
- ROUNDUP behaves like ROUND, except that it always rounds a number up.
- If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
- If num_digits is 0, then number is rounded up to the nearest integer.
- If num_digits is less than 0, then number is rounded up to the left of the decimal point.
✦ Tips
- ROUNDUP behaves like ROUND, except that it always rounds a number up.
- If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
- If num_digits is 0, then number is rounded up to the nearest integer.
- If num_digits is less than 0, then number is rounded up to the left of the decimal point.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!