Yes a 0% would not accurately determine the average - it would have to be a
blank cell!

"Pecoflyer" wrote:


Karsea;222380 Wrote:
I have an existing calculation in a column, when I drag the formula down
- I
rec'v a #DIV/O - I need to insert a "Serror" in my existing formula
but
unsure how to complete this?
My formula: In M5
=IF((H5/E5)=0,0%,(H5/E5)-1)
My formula works great, but I want it to show a blank cell (or 0%) so I
can
use the sum of M5:M66 in another cell to show an average
=AVERAGEA(M5:M66)
without rec'v a #DIV/0 (error)
Many thanks!!

If you replace it with 0%, will not your average be wrong?


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61412