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
|