ROUNDUP function

The ROUNDUP function in Excel rounds a number up, away from zero, to a specified number of digits. It ensures the result is always greater than (or less negative than) the original number.

Syntax

=ROUNDUP(number, num_digits)

Parameters

1. number (required): The number you want to round up.
2. num_digits (required): The number of digits to round to:
   • A positive value (n) rounds to n decimal places.
   • 0 rounds to the nearest whole number.
   • A negative value rounds to the left of the decimal point.

Examples

1. Round up 123.456 to 2 decimal places:

   =ROUNDUP(123.456, 2)
   

   Result: 123.46

2. Round up 123.456 to the nearest whole number:

   =ROUNDUP(123.456, 0)
   

   Result: 124

3. Round up 123.456 to the nearest tens place:

   =ROUNDUP(123.456, -1)
   

   Result: 130

4. Round up -123.456 to 1 decimal place:

   =ROUNDUP(-123.456, 1)
   

   Result: -123.5

5. Round up a number in cell A1 to 3 decimal places:

   =ROUNDUP(A1, 3)
   

Notes

• Behavior: The function always rounds numbers up, no matter the value of the digits being removed (even if they are less than 5).
• If num_digits is:
  • Greater than 0, it rounds up to the specified number of decimal places.
  • 0, it rounds up to the nearest integer.
  • Less than 0, it rounds up to the left of the decimal point.

Related Functions

• ROUND: Rounds numbers up or down based on standard rounding rules.
• ROUNDDOWN: Always rounds numbers down, toward zero.
• TRUNC: Truncates a number by removing the fractional part without rounding.
• MROUND: Rounds to the nearest multiple of a specified number.

The ROUNDUP function is particularly useful when you need to ensure that calculations meet specific thresholds, such as when estimating costs or quantities.