Excel > Functions

ROUNDUP Function

The Excel ROUNDUP function is used to round a number up to a specified number of digits.For example, round a number up to one decimal place.

The syntax for the ROUNDUP function is:

=ROUNDUP(number,num_digits)

Argument

Purpose

Number

The number you want to round up

num_digits

The number of digits you want to round the number up to.

  • If the num_digits is greater than 0, the number is rounded up to the specified number of decimal points
  • If the num_digits is 0, the number is rounded up to the nearest integer
  • If num_digits is less than 0, the number is rounded up to the left of the decimal point

Below are examples of the ROUNDUP function being used to round numbers up to a various number of digits.

Data to use for ROUNDUP function

Function

Result

=ROUNDUP(A1,2)

5.33

=ROUNDUP(A2,0)

3

=ROUNDUP(A3,1)

4.6

=ROUNDUP(A4,-1)

30

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Follow us on

Facebook  Twitter  You Tube 

Other Mathematical Functions