Round a number to a specified number of digits.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
ROUND(number, num_digits)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)Result: 3.14
Rounds to 2 decimal places.
=ROUND(1284, -2)Result: 1300
Rounds to the nearest hundred.
ROUND changes the stored value; decimal formatting only changes the display. Use ROUND when later calculations must use the rounded number.