I cannot find an error in excel

[Cathie]

I have read other answers, but no help. This is simple math, but when I put
a formula in as simples as =sum(F9+F10) or =sum(F9:F10), it is adding or
deleting a penny in my total column...help

 

[Ron Coderre]

I'm guessing Mr. McGimpsey's explanation will help:
http://www.mcgimpsey.com/excel/pennyoff.html

Does it?
***********
Regards,
Ron

XL2003, WinXP

 

[Pete_UK]

Bob Phillips has an article on rounding here:

http://www.xldynamic.com/source/xld.Rounding.html

It might explain what's happening.

Hope this helps.

Pete