Ah, misunderstood where the #DIV/0 was coming from.

In general, it's better to trap the error closest to its source, so I
would modify the formulae in A1:A10 to

=IF(COUNT(A24,O24)=2,(E24/O24)^(1/A24)-1,"No Input")

Then average with the formula I gave.



In article ,
"texanfanrocket" wrote:

=(E24/O24)^(1/A24)-1. << This is the formula in each of the 10 cells. They
are in a % format. And, unfortunately, I'm back with a #DIV/0! response.