- Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.
This post will teach you about what the ROUNDUP function is in Microsoft Excel. It will cover a summary of this function, its formula syntax structure, vital constraints of it usage, and also an example for you to experiment with and see how it works.
Summary of ROUNDUP Function
The ROUNDUP function is a mathematical function that simply rounds a number up, away from 0 (zero).
Formula Syntax of ROUNDUP Function
The ROUNDUP function syntax contains these arguments:
- Number – Required. Whichever actual number that you prefer to be rounded up.
- Num_digits – Required. The amount of digits to which you seek to round number.
Constraints of its usage
- ROUNDUP acts similarly to ROUND, however it differs in that it constantly rounds a number up.
- When num_digits exceeds 0 (zero), then number is rounded up to the stated number of decimal places.
- Anytime num_digits is 0, then number is rounded up to the closest integer.
- If num_digits is below 0, then number is rounded up to the left of the decimal point.
Copy the sample data in the table underneath, and paste it into cell A1 of an unused Excel worksheet. For formulas to indicate results, pick them, press F2, and then press Enter. If you must at any point, you can alter the column widths to gain a complete view of the whole dataset in all its wonder!
|=ROUNDUP(3.2,0)||Rounds 3.2 up to zero decimal places.||4|
|=ROUNDUP(76.9,0)||Rounds 76.9 up to zero decimal places.||77|
|=ROUNDUP(3.14159, 3)||Rounds 3.14159 up to three decimal places.||3.142|
|=ROUNDUP(-3.14159, 1)||Rounds -3.14159 up to one decimal place.||-3.2|
|=ROUNDUP(31415.92654, -2)||Rounds 31415.92654 up to 2 decimal places to the left of the decimal point.||31500|
Other Similar Topics
Expand your Office skills
Get instant Excel help
Subject to Got It terms and conditions