Explanation
In the example, cell C6 contains this formula:
=ROUND(B6,-3)
The value in B6 is 1,234,567 and the result is 1,235,000.
With the ROUND function, negative numbers for the second argument round to the left of the decimal and positive numbers round to the right of the decimal.
In this case, by supplying -3, we are telling ROUND to round the number to the 3rd place on the left – the 1000's place.
Related formulas
Round a number to nearest multiple
The MROUND function rounds a number to the nearest given multiple. The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned. You can use MROUND to round prices, times, instrument...
Round a number up to next half
The Excel CEILING function rounds a number up to a given multiple. The multiple to use for rounding is given as the second argument ( significance ). If the number is already an exact multiple, no rounding occurs. In this example, we want to round up to the nearest half, so we provide 0.5 to...
Related functions
ROUND Function
The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.
