ROUND Formula Generator
Round a number to a set number of decimal places, or left of the decimal to tens, hundreds, and thousands.
ROUND
Round a number to a set number of decimal places, or left of the decimal to tens, hundreds, and thousands.
The value to round. Can be a cell like A2, a number, or a calculation such as A2*1.0825.
2 keeps cents, 0 gives whole numbers, and negatives round left of the decimal point (-3 is the nearest thousand). Excel requires this argument, so leave a value here.
=ROUND(A2, 2)Worked Example
A supplier quote of 18,432 needs to be rounded to the nearest thousand for a summary slide.
=ROUND(18432, -3)Returns: Returns 18000. The negative num_digits rounds left of the decimal point, and -3 means the nearest thousand.
Checks Before You Paste
- •num_digits is a position, not a count of significant figures: 2 rounds to cents, 0 to whole numbers, and negative values round left of the decimal point, so -1 is the nearest ten, -2 the nearest hundred, and -3 the nearest thousand.
- •ROUND breaks ties away from zero, so ROUND(2.5, 0) is 3 and ROUND(-2.5, 0) is -3. ROUNDUP always moves away from zero, ROUNDDOWN always moves toward it, and MROUND(number, multiple) snaps to a step like 0.05 or 25 instead of a power of ten.
- •Changing a cell's number format only changes what you see: the stored value keeps every decimal, so a column that displays 10.00 + 10.00 can total 20.01. ROUND changes the value itself, which is why totals should be built from rounded cells rather than rounded displays.