Learn how to round a number to decimal places, how to estimate calculations and how to use truncation.

The Round() function returns a number rounded to the specified number of decimal places (2, down...). However, sometimes this function does not perform the operation correctly. In this article we show ...

You are probably better to simplify that budget of $1,264,312 to two decimal places: $1.26 million. Check with your media organization’s guidelines on rounding large numbers.

In cell C5, the result is 45000; the number rounds down to three decimal places to the left of the decimal point. There are two other methods to use the ROUNDDOWN function.