ROUNDUP

Formulas / ROUNDUP
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

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?
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.
What is the ROUNDUP function used for?
The ROUNDUP function is useful for financial analysis.
What other functions can the ROUNDUP function be used with?
The ROUNDUP function can be used with the MONTH function to calculate quarters from a date.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV