Description
Use this function to round a number up (in a positive direction) to a specified number of digits. Supported in Chains.
ROUNDUP always rounds a number up regardless of the digits that follow. It's useful when you need to ensure a number is not underestimated, such as in certain financial or inventory calculations.
Syntax
ROUNDUP(number, num_digits)
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
number |
Yes | The number you want to round up. | Any real number. |
num_digits |
Yes | The number of digits to which you want to round up the number. | An integer. Positive for decimal places, negative for digits left of decimal point. |
Example
Sample data
| A | B | ||
|---|---|---|---|
| 1 | Number | Description | |
| 2 | 3.14159 | Pi | |
| 3 | -2.718 | Negative e | |
| 4 | 1234.5678 | Large number | |
| 5 | 0.00123 | Small number |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Round a decimal value up to the next whole number, even if it's already close to the lower one. | =ROUNDUP(A2, 0) |
Rounds 3.14159 up to the nearest integer instead of down, regardless of the digits that follow. Result: 4 |
| Round a value up to a set number of decimal places, ensuring it's never underestimated. | =ROUNDUP(A2, 2) |
Rounds 3.14159 up to 2 decimal places rather than applying standard rounding rules. Result: 3.15 |
| Round a negative value up to a set number of decimal places, moving it further from zero. | =ROUNDUP(A3, 1) |
ROUNDUP always rounds away from zero, so −2.718 becomes more negative rather than less. Result: −2.8 |
| Round a large number up to the nearest hundred, so it's never understated. | =ROUNDUP(A4, -2) |
A negative num_digits rounds up the digits to the left of the decimal point, pushing 1234.5678 up to the next hundred.Result: 1300 |
| Round a very small value up to a set number of decimal places, guarding against undercounting. | =ROUNDUP(A5, 4) |
Rounds 0.00123 up at the 4th decimal place instead of down. Result: 0.0013 |
Notes
- If ROUNDUP is applied to text, it will result in a #VALUE! error.
- ROUNDUP is different from formatting a cell to display a certain number of decimal places, as it actually changes the value stored in the cell by removing all digits to the right of the last digit rounded.
- ROUNDUP always rounds away from zero, regardless of whether the number is positive or negative.
- If
num_digitsis positive (greater than 0), ROUNDUP rounds up to the specified number of decimal places. - If
num_digitsis 0, ROUNDUP rounds up to the nearest integer. - If
num_digitsis negative (less than 0) , ROUNDUP rounds up the digits to the left of the decimal point.
- If
- ROUNDDOWN always rounds towards zero.
- ROUND follows standard rounding rules: if the digit to the right of the rounding position is 5 or greater, it rounds up; otherwise, it rounds down.
- Applying ROUND to a positive number will increase it in a positive direction, applying ROUND to a negative number will increase it in a negative direction. ROUNDUP differs from the ROUND and ROUNDDOWN functions in the following ways:
Tips
- ROUNDUP can be useful in financial calculations where you want to err on the side of caution, for example to ensure a value is not underestimated in pricing or cost calculations.
- For displaying numbers with a certain number of decimal places without changing the underlying value, use cell formatting instead of ROUNDUP.
- ROUNDUP can be combined with other functions such as SUM or AVERAGE for more complex calculations.
- Consider using the other rounding functions (linked in Related functions) if you need to round numbers in a different manner.