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.

Could you provide an example?


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

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

The values a

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