Percentage formula in excel

  • Thread starter Thread starter Trevea
  • Start date Start date
T

Trevea

I have 4 columns which I have set up with a formula to calculate percentage.
The 4 column formulas should equal 100% but they equal 106%. Can you help?
 
Trevea said:
I have 4 columns which I have set up with a formula to calculate percentage.
The 4 column formulas should equal 100% but they equal 106%. Can you help?
Click to expand...

Column Totals 971,978.64 4,050.00 734,810.51 247,068.13
%from formulas 1.86% 0.42% 75.92%
25.53%
formulas e38/d38 f38/3/38
G38/(e38-f38) h38/(e38-f38)
 
Trevea said:
Column Totals 971,978.64 4,050.00 734,810.51 247,068.13
%from formulas 1.86% 0.42% 75.92%
25.53%
formulas e38/d38 f38/3/38
G38/(e38-f38) h38/(e38-f38)
Click to expand...

The percentage totals are now 103.74%
 
Column Totals
d38 52,301,407,62
e38 971,978.64
f38 4050.00
g38 734,810.51
h38 247,068.13

Formulas
e38/d38
f38/e38
g38/(e38-f38)
h38/(e38-f38)
f38/e38
 
Why do you expect the percentages to add to 100%? You're not dividing by the
sum of the numbers.

If you're want to calculate the percentage of the total, first make sure
you're dividing by the total.

Regards,
Fred.
 
Back
Top