Excel ROUNDUP function

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.

Related Functions

Excel ROUNDDOWN function

The Excel ROUNDDOWN function rounds a number down, away from zero, to a specified number of digits, useful for conservative estimations.

Excel FLOOR function

The Excel FLOOR function rounds numbers down to the nearest multiple of significance, useful for inventory and budget control.

Excel TRUNC function

The Excel TRUNC function truncates a number to an integer by removing the fractional part, useful for precise mathematical operations.

Excel CEILING function

The Excel CEILING function rounds numbers up to the nearest multiple of significance, ideal for pricing and budgeting calculations.

Excel ROUND function

The Excel ROUND function rounds a number to a specified number of digits, crucial for accurate financial and scientific calculations.

Content Navigation