ROUNDUP
Formulas / ROUNDUPRounds a number up to a specified number of decimal places
ROUNDUP(number, num_digits)
- number - the number to round up
- num_digits - the place where numbers should be rounded
Examples
=ROUNDUP(A1,1)The ROUNDUP function can be used to round a number up to the first decimal place. For example, this will round A1 to the first decimal place. This is useful for when you need to quickly round a number to the nearest tenth.
=ROUNDUP(A1,0)The ROUNDUP function can also be used to round a number up to the nearest whole number. This example, will round A1 to the nearest whole number. This is useful for when you need to quickly round a number up to a single value.
=ROUNDUP(A1,-1)The ROUNDUP function can also be used to round a number up to the nearest ten. This example, will round A1 to the nearest ten. This is useful for when you need to quickly round a number to 10, 20, 30 and so on.
Summary
The ROUNDUP function rounds up all numbers, not just numbers five or greater, to a given decimal place.
- The ROUNDUP function takes two arguments: the number to be rounded, and the number of digits to round to. If num_digits is negative, the number is rounded to the right side of the decimal.
- ROUNDUP always rounds numbers up, regardless of the number to be rounded.
Frequently Asked Questions
What is the ROUNDUP function?
What is the ROUNDUP function used for?
What other functions can the ROUNDUP function be used with?
