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'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

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

On Aug 11, 9:30 pm, Cathie <Cat...@discussions.microsoft.com> 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