Round a number to a specified number of digits.
Syntax
ROUND(number, num_digits)Arguments
numberrequired
The value to round.
num_digitsrequired
How many digits to round to.
ROUND rounds a value to the number of decimal places you choose. Use a positive num_digits for decimals, 0 for whole numbers, and a negative value to round to tens, hundreds, or thousands. ROUNDUP and ROUNDDOWN force the direction.
=ROUND(3.14159, 2)→3.14Rounds to 2 decimal places.
=ROUND(1284, -2)→1300Rounds to the nearest hundred.
Pick the value
Reference the cell or calculation to round.
Choose precision
Use 2 for currency cents, 0 for whole units, negatives for tens/hundreds.
ROUND changes the stored value; decimal formatting only changes the display. Use ROUND when later calculations must use the rounded number.