Numbers not adding up

[Guest]

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?

 

[Niek Otten]

Even if you format cells to show no decimals, they are still there, so they
are added to the total too.
To avoid that, don't just format, but use a ROUND() formula. Or, often a
good solution in financial spreadsheets, apply Tools>Options>Calculation,
check Precision as displayed.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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?