ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adding a group of numbers in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/108550-adding-group-numbers-excel.html)

alyn21

adding a group of numbers in Excel
 
I have Windows XP on this computer. When I try to add a group of
numbers in excel the final result is not accurate. It is off by between
..01 to .02.
This happens in some cases and in others it does not. It is happening
often enough to be a problem.
Any information that can help me with this problem would be greatly
appreciated as it is slowing down my productivity since I have to check
every group of numbers I add to make sure it is accurate.


Ron Coderre

adding a group of numbers in Excel
 
See Mr. McGimpsey's website for an explanation:

http://www.mcgimpsey.com/excel/pennyoff.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"alyn21" wrote:

I have Windows XP on this computer. When I try to add a group of
numbers in excel the final result is not accurate. It is off by between
..01 to .02.
This happens in some cases and in others it does not. It is happening
often enough to be a problem.
Any information that can help me with this problem would be greatly
appreciated as it is slowing down my productivity since I have to check
every group of numbers I add to make sure it is accurate.




All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com