Rounding-off Problem...

[Manhar]

I use Excel 2003. I hope I can explain this problem clearly.

Cells D6 thru D9 each contain the result of a simple formula. Each of these cells has a two-decimal dollar value. When I use autosum to place the total of these cells into -say- E9, the result is NOT that of the five amounts in question. It is out by 1 cent, and the reason appears to be that Excel is taking into account a third (invisible) decimal place.

How do I tweak this so that the total in E9 is the sum of what is VISUAL in the five cells D6-D9?

Thanks!

Manhar

[daddylonglegs]

Do cells D6:D9 have formulas? If so you could introduce a ROUND function there to round to 2 decimal places, then the display will match the value and when you sum them you'll get what you expect,

.....alternatively sum with this formula which rounds the values and then sums them

=SUMPRODUCT(ROUND(D6:D9,2))

[rasonline]

you would rather round off the answers in cell d6 through d9 and then let the autosum work normally. to do this, simply prefix your existing formula with =ROUND(FORMULA,2) where FORMULA represetns the existing formula in d6.

[rasonline]

Dope. sorry, didnt see that daddylonglegs beat me to it.