Thread: sum difference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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