How to Use the ROUNDUP Function in Excel
In this tutorial, you'll learn how to use the Excel ROUNDUP function.
ROUNDUP is a function to round a number up away from 0.
ROUNDUP Syntax
The syntax of the ROUNDUP() function is as follows:
=ROUNDUP(number, num_digits)
Return value
A rounded number
Arguments
- number: the number that you want to round up
- num_digits: the number of digits to which you want to round a number
Remarks
- If num_digits argument is less than 0, the number rounded up to the left of the decimal point. However, if it's greater than 0, then the number is rounded up to the specified number of decimal places.
- If num_digits is set to 0, ROUNDUP rounds the number up to the nearest integer.
- ROUNDUP behaves like ROUND. The only difference is that ROUNDUP always rounds a number up.
ROUNDUP Example
Example 1
The following example sets num_digits to 0 and rounds 47.2515 up to the nearest integer:
=ROUNDUP(47.2515,0)
The above formula returns 48.
Example 2
The following example sets num_digits to 0 and rounds 45.9192 up to the nearest integer:
=ROUNDUP(47.9192,0)
The above formula returns 48.
Example 3
The following example sets num_digits to 1 and rounds 47.2515 up to one decimal place:
=ROUNDUP(47.2515,1)
The above formula returns 47.3.
Example 4
The following example sets num_digits to 1 and rounds 47.2616 up to one decimal place:
=ROUNDUP(47.2616,1)
The above formula returns 47.3.
Example 5
The following example sets num_digits to 2 and rounds 47.2516 to up two decimal places:
=ROUNDUP(47.2516,2)
The above formula returns 47.26.
Example 6
The following example sets num_digits to 2 and rounds 47.2616 to up two decimal places:
=ROUNDUP(47.2616,2)
The above formula returns 47.27.
Example 7
The following example rounds 691.32 up to one decimal place to the left of the decimal points and returns 700:
=ROUNDUP(691.32,-1)
Example 8
You can round a number up to the nearest multiple of 100, as the following example shows:
=ROUNDUP(691.32,-2)
The above formula returns 700:
Example 9
You can round a number up to the nearest multiple of 1000, as the following example shows:
=ROUNDUP(691.32,-3)
The above formula returns 1000.
In this tutorial, you've learned how to use the Excel ROUNDUP function.
ROUNDUP is a function to round a number up to a specified number of digits.