"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