Numbers not adding up

[Big Jilm]

I set up a complicated spreadsheet in a workbook where I am
determining percentage ownership of our equity fund, and from that,
how many shares will be printed on the stock certificates for each of
the 121 members. Well, the numbers are the results of forumlas, and
are showing up and totalling ok, however, when I enter manually the
results in a different workbook, I am 21 shares short of the original
list, no matter how many times I cross check and double check.

I am not using any decimal places on the first or 2nd workbook totals,
however, on the first workbook, it does round up or down to a whole
numbers, as each result has decimal places I am not showing.

So, somehow in the translation, i am not doing something correctly.

Can anyone be of help in getting my manually entered 2nd workbook to
match my automatically calculated 1st workbook?

 

[Bernard Rey]

I set up a complicated spreadsheet in a workbook where

I am determining percentage ownership of our equity fund,
and from that, how many shares will be printed on the
stock certificates for each of the 121 members. Well,
the numbers are the results of forumlas, and are showing
up and totalling ok, however, when I enter manually the
results in a different workbook, I am 21 shares short of
the original list, no matter how many times I cross
check and double check.

I am not using any decimal places on the first or 2nd
workbook totals, however, on the first workbook, it does
round up or down to a whole numbers, as each result has
decimal places I am not showing.

So, somehow in the translation, i am not doing something
correctly.

Could you give some details about how you are rounding the
results. It seems you are not rounding, but simply setting
the cell format to display them without any decimals: not
showing them doesn't mean they don't exist, and they are
included in the summing cell. When reporting manually the
visible numbers, you do cut off the hidden decimal part of
each, thus obtaining a different total, at least this is
what I guess is happening.

If this makes sense, the answer would then be to round the
result, not only the displaying of the result. Using the
ROUND function:

=ROUND(Your original Formula,0)

If this doesn't match you needs, please give some more
details,