Take a look he

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
Stephanie DeCou <Stephanie wrote:

I saw a post that asked this question and the guy who answered made him look
stupid but I agree with the man.

I use Excel to do accounting work. What happens is the numbers add as the
original number and not the rounded number. That can lead to some serious
miscalculations.

Is there a formula that can be used when multiplying or dividing that will
round the number to the nearest hundredth and have the column properly add
the rounded numbers? The way it is right now, it adds the whole number not
the rounded.

I think the IRS might have something to say if the pennies start adding up
to $100s of dollars in missed tax monies.