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