Thursday, January 26, 2012

What is the best formula to calculate a percentage average in excel?

I have a table with a column filled with percentages (positives, negatives, zeros) , for example:

-10%

5%

0%



I need a formula to calculate an average for these percentages. this can be done using a geometric media, but it does not seem to work with negatives and zeros. This is best I could find:

=POWER(PRODUCT(B51:N51),

(1/COUNT(B51:N51)))



Any help would be appreciated..!What is the best formula to calculate a percentage average in excel?
=AVERAGE(B51:N51)
  • harry potter games online
  • russian translator
  • No comments:

    Post a Comment