It's important to remember that setting a display format doesn't change
the underlying value. If you have

0.0049

in a cell set to 3 decimal places, it will display as

0.005

but if rounded to 2 digits, it will round to 0.00 rather than 0.01.

To prevent that, you could wrap your calculation with ROUND(), e.g.,:

=ROUND(<your calc here,3)

in which case 0.0049 will be rounded to 0.005, and subsequent rounding
will round up.


In article ,
Jbagger wrote:

I am having rounding errors in Excel. When I use a formula to make a
calculation, the resulting numbers will not round correctly when a 5 is the
third decimal place. Iit always rounds down, instead of up. I can enter the
same number in another cell with no formula and it rounds correctly. This
results in very inconsistent calculations. Any ideas or fixes? Thank you!