I cannot find an error in excel
 

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

I cannot find an error in excel
 

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

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

XL2003, WinXP


"Cathie" wrote:

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

I cannot find an error in excel
 

Bob Phillips has an article on rounding he

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

It might explain what's happening.

Hope this helps.

Pete

On Aug 11, 9:30 pm, Cathie wrote:
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