LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"