Adding % to gether?

[Snowfire]

This seems like a simple task to add 3 percentage figures from tree
different cells into a forth cell..... ie.

1.12% , 2.03% , 0.88% to give ... 4.03% in total cell
But either I have a corruption or I have lost the plot!!!

I get a figure that bears no resemblance to the value.... tried
formatting the cell as a % then a number..... then * 100 / 100 in
every combination/s and still it fails.

Please embarrass me with a simple solution.

 

[Gord Dibben]

I get 4.03%

Are the percentages derived or just manually entered?

What is the figure you get that bears no resemblance?


Gord Dibben MS Excel MVP

 

[JoeU2004]

This seems like a simple task to add 3 percentage
figures from tree different cells into a forth cell
[....]
I get a figure that bears no resemblance to the value

Well, it would help us help you if you post __all__ of the numbers involved.

But here are two observations which might help you.

First, bear in mind that the numbers you see (1.12%, 2.03% and 0.88%) are
probably rounded values. For example, the displayed value of 1.12% can be
anything from about 1.115% to about 1.12499999999999%. Consequently, their
sums can be anything between about 4.015% to about 4.045%.

However, if that were the issue, I think you would see some "resemblance" to
what you expect. You say you don't.

Second, keep in mind that (x1/y1) + (x2/y2) + (x3/y3) does not equal the
correct sum (x1+x2+x3) / (y1+y2+y3). So if 1.12%, 2.03% and 0.88% are
computed by x1/y2, x2/y2 and x3/y3, you cannot compute the total percentage
by simply summing the individual percentages.

Again, if neither of those observations helps you see the problem, please
post more details.


----- original message -----

 

[Snowfire]

This seems like a simple task to add 3 percentage
figures from tree different cells into a forth cell
[....]
I get a figure that bears no resemblance to the value

Well, it would help us help you if you post __all__ of the numbers involved.

But here are two observations which might help you.

First, bear in mind that the numbers you see (1.12%, 2.03% and 0.88%) are
probably rounded values.  For example, the displayed value of 1.12% canbe
anything from about 1.115% to about 1.12499999999999%.  Consequently, their
sums can be anything between about 4.015% to about 4.045%.

However, if that were the issue, I think you would see some "resemblance"to
what you expect.  You say you don't.

Second, keep in mind that (x1/y1) + (x2/y2) + (x3/y3) does not equal the
correct sum (x1+x2+x3) / (y1+y2+y3).  So if 1.12%, 2.03% and 0.88% are
computed by x1/y2, x2/y2 and x3/y3, you cannot compute the total percentage
by simply summing the individual percentages.

Again, if neither of those observations helps you see the problem, please
post more details.

----- original message -----

This seems like a simple task to add 3 percentage figures from tree
different cells into a forth cell..... ie.

1.12%  ,    2.03%  ,   0.88%   to give ...  4.03%  in total cell
But either I have a corruption or I have lost the plot!!!

I get a figure that bears no resemblance to the value.... tried
formatting the cell as a % then a number..... then * 100 / 100 in
every combination/s and still it fails.

Please embarrass me with a simple solution.- Hide quoted text -

- Show quoted text -

Thanks for the replies Gord, Joe. Your second point hit home Joe. I
see the problem now, you can't just add calculated % in the way I have
done. I was calculating a collective from the calculate sub %.
Since the % are displayed only to inform the user of met/missed
targets I will approach this from another angle...... thanks again.
Mike.