Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |