-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)
No comments:
Post a Comment