ROUND
Formulas / ROUNDRounds 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.
Need help with Formulas?
Frequently Asked Questions
What is the ROUND function?
What arguments does the ROUND function take?
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.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.