Percentage formulas now post
I have 4 columns with the following
Column Totals
d38 52,301,407,62
e38 971,978.64
f38 4050.00
g38 734,810.51
h38 247,068.13
I have entered the following formulas in row 39 with a % format
e38/d38
f38/e38
g38/(e38-f38)
h38/(e38-f38)
The 4 columns add up to 103.74% the should equal 100%.
How can I fix this?
|