Thread: sum difference
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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