Hi All

This might be an age old problem, but I just wanted to see if I wasn't
missing something obvious in my code.

Basically I have say 31 people (this figure can range from 10 to 100) who
are put into 8 categories. Once they have been categorised I simply need to
show how many are in each category as a number and as a percentage. Now the
number aspect of display is easy, but I'm coming unstuck with the percetange
aspect.

In essence as I do my % calc for each category sometimes certain values are
1% less or more than they should be and as you add up the displayed figures
the total might come out at 99% or 101%, which looks daft.

An example of a display problem is as follows

1 0 2 9 11 5 0 2 = 30 people
3% 0% 7% 30% 37% 17% 0% 7% = 101% !!!!

My code for each percentage value is simply:

Round((intPeopleCount / intTotalPeopleCount) * 100, 0) & "%"

I really want to make this work, but it seems fraught with issues!!

Any ideas?

Thanks

Hi Mojo,

First use percentage format in all the cells you want to display as
percentages, including the cell that will contain the 100% result. Then in
all the peoples percentage cells use the following formula:

=C1*0.01/(SUM($C1:$H16)*0.01)

In the result cell simply use a sum formula of all the percentage people

Hope this helps.

--
A. Ch. Eirinberg


"Mojo" wrote:

> Hi All
>
> This might be an age old problem, but I just wanted to see if I wasn't
> missing something obvious in my code.
>
> Basically I have say 31 people (this figure can range from 10 to 100) who
> are put into 8 categories. Once they have been categorised I simply need to
> show how many are in each category as a number and as a percentage. Now the
> number aspect of display is easy, but I'm coming unstuck with the percetange
> aspect.
>
> In essence as I do my % calc for each category sometimes certain values are
> 1% less or more than they should be and as you add up the displayed figures
> the total might come out at 99% or 101%, which looks daft.
>
> An example of a display problem is as follows
>
> 1 0 2 9 11 5 0 2 = 30 people
> 3% 0% 7% 30% 37% 17% 0% 7% = 101% !!!!
>
> My code for each percentage value is simply:
>
> Round((intPeopleCount / intTotalPeopleCount) * 100, 0) & "%"
>
> I really want to make this work, but it seems fraught with issues!!
>
> Any ideas?
>
> Thanks
>
>
>
>

because you're actually rounding values, you're altering them ...so it's
quite likely that your numbers won't sum to 100%

eg 34. 34 + 34.34 + 31.32= 100
BUT 34.3 + 34.3 +31.3 = 99.9

I'd recommend that you leave your formula unadjusted,
=(intPeopleCount / intTotalPeopleCount) * 100

and that you FORMAT the cells to show integegers.

"Mojo" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hi All
>
> This might be an age old problem, but I just wanted to see if I wasn't
> missing something obvious in my code.
>
> Basically I have say 31 people (this figure can range from 10 to 100) who
> are put into 8 categories. Once they have been categorised I simply need
> to
> show how many are in each category as a number and as a percentage. Now
> the
> number aspect of display is easy, but I'm coming unstuck with the
> percetange
> aspect.
>
> In essence as I do my % calc for each category sometimes certain values
> are
> 1% less or more than they should be and as you add up the displayed
> figures
> the total might come out at 99% or 101%, which looks daft.
>
> An example of a display problem is as follows
>
> 1 0 2 9 11 5 0 2 = 30
> people
> 3% 0% 7% 30% 37% 17% 0% 7% = 101% !!!!
>
> My code for each percentage value is simply:
>
> Round((intPeopleCount / intTotalPeopleCount) * 100, 0) & "%"
>
> I really want to make this work, but it seems fraught with issues!!
>
> Any ideas?
>
> Thanks
>
>
>