avg percent

  • Thread starter Thread starter robin
  • Start date Start date
R

robin

could someone please help with this calculation. it does
not seem that difficult but i can't seem to get it.
i need the formula for column i.
col c = given value
col d = given value
col e = percent of col c to col d (col c / col d)
col f = given value
col g = given value
col h = percent of col f to col g (col f / col g)
col i = i need to know the average percent of col e & col
h. the percents in col e and col h are sometimes
negatives.
thanks for anyone's helps on this one.
r
 
You can average numbers even if they are negative. As you only have two
numbers (col e and col h), the average is (col e + col h) / 2.

Does this solve your problem?
 
Back
Top