Rounds 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

`=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.

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.

The ROUNDUP function is a math and trigonometry function in Sourcetable. It is used to round numbers up from zero and eliminates digits in the least significant position.

The ROUNDUP function is useful for financial analysis.

The ROUNDUP function can be used with the MONTH function to calculate quarters from a date.

Drop CSV