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.
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.
Pingback: INT Function - Excelbuddy.com