Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum difference
When I am working in Excel I frequently have noticed simple addition math
functions not calculating correctly -- as simple as $21.26 + $ $6.80 summing up to $28.07 instead of correctly $28.06. I have checked cell formatting on the cells affected and do not see any formatting issues that would explain this. Has any one else ever noticed this? It's minor, but I would like to resolve the issue if any one else has had this happen and can offer some insight. -- Thanks for your time. Kaye |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum difference
Where do the values of $21.26 and $6.80 come from? If these are calculations,
and it is formatted to 2 decimals, then that could explain your problem. What if $21.26 is actually $21.26443 and $6.80 is actually $6.8019, then, when added together, they are actually $28.06633, which would appear as $28.07. -- John C "Kaye" wrote: When I am working in Excel I frequently have noticed simple addition math functions not calculating correctly -- as simple as $21.26 + $ $6.80 summing up to $28.07 instead of correctly $28.06. I have checked cell formatting on the cells affected and do not see any formatting issues that would explain this. Has any one else ever noticed this? It's minor, but I would like to resolve the issue if any one else has had this happen and can offer some insight. -- Thanks for your time. Kaye |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum difference
Possibly 21.26 is really 21.2643220... and 6.80 is 6.803452
So, when you add those together, it rounds up. "Kaye" wrote: When I am working in Excel I frequently have noticed simple addition math functions not calculating correctly -- as simple as $21.26 + $ $6.80 summing up to $28.07 instead of correctly $28.06. I have checked cell formatting on the cells affected and do not see any formatting issues that would explain this. Has any one else ever noticed this? It's minor, but I would like to resolve the issue if any one else has had this happen and can offer some insight. -- Thanks for your time. Kaye |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum difference
Following is taken from http://www.cpearson.com/excel/rounding.htm;
Under normal circumstances, Excel always stores and manipulates numbers as 8-byte "Double Precision Floating Point" numbers, or "Doubles". Excel's internal storage of the number is not affected by the way that you may choose to format a number for display. For example, if a cell contains the formula =1/3, Excel always treats this value as 0.3333€¦, regardless of how many decimal places you choose to display on the worksheet. Even if you choose to display the value as simple "0.3", Excel still retains the complete number as the value of the cell. __________________________________________________ _ So what you have observed is probably due to rounding... If you enter the nos as you have shown then you will always get 28.06 and if your nos are actually, say, 21.264 and 6.801 you will get 28.07... "Kaye" wrote: When I am working in Excel I frequently have noticed simple addition math functions not calculating correctly -- as simple as $21.26 + $ $6.80 summing up to $28.07 instead of correctly $28.06. I have checked cell formatting on the cells affected and do not see any formatting issues that would explain this. Has any one else ever noticed this? It's minor, but I would like to resolve the issue if any one else has had this happen and can offer some insight. -- Thanks for your time. Kaye |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
what is the difference !!! | Excel Discussion (Misc queries) | |||
difference between the 2 | Excel Worksheet Functions | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
up down bar value (difference) | Charts and Charting in Excel |