Calculating Percentages

[tifosi3]

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.

 

[VoG via OfficeKB.com]

Could you provide an example?

 

[bj]

What are your input values?

 

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[tifosi3]

The values are:

119/128 and 8/128

The formulas are F21/B21 and D21/B21

The return values are 93% and 6%

Thanks

 

[VoG via OfficeKB.com]

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

 

[tifosi3]

Thanks, that was embarrassing

 

[bj]

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