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.

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

On Sun, 23 Aug 2009 10:11:03 -0700 (PDT), Snowfire
wrote:

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.

"Snowfire" wrote:
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" wrote in 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.

On 23 Aug, 19:16, "JoeU2004" wrote:
"Snowfire" wrote:
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" wrote in 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.