View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Lost at Sea
 
Posts: n/a
Default The Sum of It All

No, everything is added to each other. I really don't understand this at
all. I mean, at first I thought that I was just absolutely horrible in math
and had no clue what it was that I was doing, however, I went and added up
the categories for the subtotals via Excel formulas, and nothing is adding
up. The differences are anywhere from $22.01 between database 1 and 2 and
$225.00 between database 1 and three. I'm totally lost here. :(
--
--"The second hand unwinds..."--

Vaya con Dios, my darling;
Vaya con Dios my love.


"Mark Lincoln" wrote:

They are all only two decimal places.
I am trying to do these databases with
currency. Would the currency have
anything to do with it at all?


That shouldn't have anything to do with it as far as I know.

If the figures are all entered as you showed in your original post then
I would be at a loss to explain the problem.

If any figures are calculated, that's where the discrepancy can arise
between the figures you see and the actual underlying values. If the
*values* are different by the tiniest fraction, you won't get them to
show as equal.

Are any of the figures the result of dividing one number by another?
That often traps me unless I round the results.