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

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

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.

The ROUND function rounds a number to a given number of digits.

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.

- The ROUNDUP function always rounds up.
- The ROUNDDOWN function always rounds down.
- The MROUND function rounds to a specific multiple.

Drop CSV