Excel ROUNDUP Function with Examples

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.


See also:
Excel MIN Function with Examples
Excel COUNTA Function with Examples
Excel COUNTBLANK Function with Examples
Excel SUMIFS Function with Examples
Excel COUNTIFS Function with Examples

Leave a Comment