ROUND

Formulas / ROUND
Rounds a number to the desired number of digits specified
ROUND(number, num_digits)
  • number - The number to round
  • num_digits - The place to round to

Examples

  • =ROUND(A1,0)

    The ROUND function can be used to round a value to the nearest integer. To do this, use the above syntax. This will round the value of A1 to the nearest integer.

  • =ROUND(A1,1)

    If you wish to round to the nearest decimal place, you can use the following syntax. This will round the value of A1 to the first decimal place.

  • =ROUND(A1,2)

    To round to the second decimal place, use the syntax. This will round the value of A1 to the second decimal place.

  • =ROUND(A1,-1)

    You can round to whole numbers like the nearest ten or hundred by using a negative number in the second argument. This example, will round to the nearest 10.

Summary

The ROUND function is a Sourcetable function that rounds a number to the nearest whole number or fraction.

  • The ROUND function rounds a number to a set number of digits, with the precision of the rounding based on the num_digits argument.
  • The last significant digit determines whether the result is rounded up or down: the number is rounded up if the last significant digit is ≥ 5, and rounded down if the last significant digit is < 5.
  • Note that the ROUND function throws a #VALUE! error if the number is not a number.


Frequently Asked Questions

What is the ROUND function?
The ROUND function rounds a number to a given number of digits.
What arguments does the ROUND function take?
The ROUND function takes two arguments: number and num_digits. Both arguments are required. The num_digits argument determines how many digits to round to.
What other functions are related to the ROUND function?
  • The ROUNDUP function always rounds up.
  • The ROUNDDOWN function always rounds down.
  • The MROUND function rounds to a specific multiple.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.