Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey everyone. Excel 2003.
I will frequently add up a range of cells (all dollar amounts that were typed in manually). When I add those numbers up with the calculator, let's say they equal $1865.60. Then when I take them and put the same exact numbers into a Column and do an autosum, the number comes up $1865.60. GREAT! But when I do an =SUM(... and then highlight the cells containing the same numbers, the total come up $1865.59 (one penny off). Of course, it's not all the time. But I've noticed a difference sometimes between AutoSum and manually entering a forumla (usually by just a penny). Why is this happening and how can I fix this before I loose my mind? Any help would be appreciated. THANKS! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exel 2007 penny off | Excel Discussion (Misc queries) | |||
Adding Incorrectly - off by 1 penny | Excel Discussion (Misc queries) | |||
AutoSum lost a penny | Excel Worksheet Functions | |||
My accounting program is a penny off, Why? | Excel Worksheet Functions | |||
In Excel the total is off by a penny. | Excel Worksheet Functions |