Purpose
Round a number to a given number of digits
Return value
A rounded number.
Syntax
=ROUND (number, num_digits)
Arguments
- number – The number to round.
- num_digits – The number of digits to which number should be rounded.
Usage notes
Round works by rounding numbers 1-4 down, and rounding numbers 5-9 up.
The ROUND function rounds numbers to a specified level of precision. It can round to the right or left of the decimal point.
If num_digits > 0, number is rounded to the specified number of decimal places to the right of the decimal point.
If num_digits < 0, number is rounded to the left of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).
If num_digits = 0, number is rounded to the nearest integer.
