View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevea Trevea is offline
external usenet poster
 
Posts: 5
Default 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?