ROUNDUP Function

The ROUNDUP function in Excel rounds numbers up a specified decimal place. This function rounds up all of the numbers.

Syntax:

=ROUNDUP (number,num_digits) 

Arguments:

  • number – The number to round up.
  • num_digits – The number of digits to which number should be rounded up.

Round to the Right

=ROUNDUP(A1,1) – Round up to 1 decimal place
=ROUNDUP(A1,2) – Round up to 2 decimal places
=ROUNDUP(A1,3) – Round up to 3 decimal places
=ROUNDUP(A1,4) – Round up to 3 decimal places
=ROUNDUP(A1,5) – Round up to 3 decimal places

Round to the Left

=ROUNDUP(A1,0) – Round up to the nearest whole number
=ROUNDUP(A1,-1) – Round up to nearest 10
=ROUNDUP(A1,-2) – Round up to nearest 100
=ROUNDUP(A1,-3) – Round up to nearest 1000
=ROUNDUP(A1,-4) – Round up to nearest 10000

ROUNDUP Function Example

Let’s look at the following example.

ROUNDUP Function

Rounding Functions in Excel

ROUND Function – Rounds to a specified number of digits.

ROUNDUP Function – Rounds numbers up a specified decimal place.

ROUNDDOWN Function – Returns a number rounded down to a specified number of places.

FLOOR Function – Rounds a given number down to the nearest specified multiple

MROUND Function – Round a number up or down to a given multiple.

CEILING Function – Rounds a given number up to the nearest specified multiple.

INT Function – Rounds a number down to the nearest integer.

TRUNC Function – Returns a truncated number based on a specified number of digits.