Replace #Divo/0! Error With Blank Cell

J

Jeff at Work

I have a wrksht with an average function for various different products, some products have no data and therefore when the cell range is averaged it pulls up the div/0 error, how can you go into the function and replace the div/0 error with a blank cell.
 
D

David J. Braden

IF(COUNT(myRange)<1,"no data",AVERAGE(myRange))

HTH
Dave Braden

Jeff at Work said:
I have a wrksht with an average function for various different products,
Click to expand...
some products have no data and therefore when the cell range is averaged it
pulls up the div/0 error, how can you go into the function and replace the
div/0 error with a blank cell.
 
Top