In the averaged cells, AB31...AN31, it is possible they may all b
blank. Using the AVERAGE function returns the error #DIV/0!. Is ther
a way to have the below formula, located in cell Z31, enter a blank?
This formula still enters ther error. Or is there another construc
for the formula?
=IF((AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31)=" #DIV/0!"),"",AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31 )
--
Phil H
-----------------------------------------------------------------------
Phil H.'s Profile:
http://www.hightechtalks.com/m22
View this thread:
http://www.hightechtalks.com/t228156