Summary
The Excel ROUNDUP function rounds a number up, away from zero, to a specified number of digits. It is commonly used in scenarios where you need to increase a number to the nearest specified decimal or integer, such as in financial estimations, calculating dimensions in construction, or when working with specific measurement standards.
Syntax
=ROUNDUP(number, num_digits)
- number: The number to round up
- num_digits: The number of digits to which you want to round up the number
Return value
The number rounded up to the specified number of digits.
How to use
Use ROUNDUP by entering the number to be rounded and specifying the number of digits for rounding. If num_digits is greater than 0, the function rounds up to the specified number of decimal places. If num_digits is 0, it rounds up to the nearest integer. If num_digits is less than 0, it rounds up to the left of the decimal point.
Examples
Simple ROUNDUP
Rounding Up to a Specific Decimal Place: To round a number up to two decimal places:
=ROUNDUP(3.14159, 2)
This formula rounds 3.14159 up to 3.15.
ROUNDUP to Tens and Hundreds
Rounding up with negative num_digits: Rounding a number up to the nearest ten:
=ROUNDUP(157, -1)
Rounds 157 up to 160 (nearest ten).
ROUNDUP for Clean Display
Rounding Up Inventory Counts: Applying ROUNDUP in inventory calculations:
=ROUNDUP(Quantity, 0)
Rounds up the Quantity to the nearest whole number, useful for inventory counts where partial items are not counted.
Additional Notes
- ROUNDUP always rounds numbers up (away from zero), making it distinct from the general ROUND function.
- It is especially useful in situations where you need to ensure that estimations are not falling short due to rounding down.