# 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.