Calculating Percentages

I am doing a simple percentage calculation, however the two percentages are
not adding up to 100%, is there a reason for this? Thanks for any help with
this matter.

What are your input values?

"tifosi3" wrote:

> I am doing a simple percentage calculation, however the two percentages are
> not adding up to 100%, is there a reason for this? Thanks for any help with
> this matter.
>

We'd need to have the exact numbers you're working with.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"tifosi3" <tifosi3@discussions.microsoft.com> wrote in message
news:F58B4A0D-98D7-4208-8822-FE3A65BEC1EA@microsoft.com...
> I am doing a simple percentage calculation, however the two percentages
are
> not adding up to 100%, is there a reason for this? Thanks for any help
with
> this matter.
>

Could you provide an example?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

The values are:

119/128 and 8/128

The formulas are F21/B21 and D21/B21

The return values are 93% and 6%

Thanks

"bj" wrote:

> What are your input values?
>
> "tifosi3" wrote:
>
> > I am doing a simple percentage calculation, however the two percentages are
> > not adding up to 100%, is there a reason for this? Thanks for any help with
> > this matter.
> >

119 + 8 does not equal 128. Hence they do not add up to 100%.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

Thanks, that was embarrassing

"VoG via OfficeKB.com" wrote:

> 119 + 8 does not equal 128. Hence they do not add up to 100%.
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200507/1
>

I wish I could say I have never done the same thning, but I can't

"tifosi3" wrote:

> Thanks, that was embarrassing
>
> "VoG via OfficeKB.com" wrote:
>
> > 119 + 8 does not equal 128. Hence they do not add up to 100%.
> >
> >
> > --
> > Message posted via OfficeKB.com
> > http://www.officekb.com/Uwe/Forums.a...excel/200507/1
> >