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
<(E-Mail Removed)> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
news:3ed0405e-ffef-4621-96db-(E-Mail Removed)...
> 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" <joeu2...@hotmail.com> wrote:
> "Snowfire" <mike.r.har...@blueyonder.co.uk> 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% 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 -----
>
> "Snowfire" <mike.r.har...@blueyonder.co.uk> wrote in message
>
> news:3ed0405e-ffef-4621-96db-(E-Mail Removed)...
>
>
>
> > 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.