| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
| Excel: Compilation error in Module 1. How can I find it? | Excel Discussion (Misc queries) | |||
| Find Error, Hyperlink.. | Excel Discussion (Misc queries) | |||
| how to find an error | Excel Discussion (Misc queries) | |||
| help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
Linear Mode
