Percentage formula in excel
 

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?

Percentage formula in excel
 

Yes, if you tell us what formula and data you have.

Regards,
Fred

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

Percentage formula in excel
 

"Trevea" wrote:

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?

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)

Percentage formula in excel
 

"Trevea" wrote:



"Trevea" wrote:

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?

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)

The percentage totals are now 103.74%

Percentage formula in excel
 

"Trevea" wrote:



"Trevea" wrote:



"Trevea" wrote:

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?

Sorry the last post had incorrect information

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

Percentage formula in excel
 

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.

"Trevea" wrote in message
...


"Trevea" wrote:



"Trevea" wrote:



"Trevea" wrote:

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?

Sorry the last post had incorrect information

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