Replace #Divo/0! Error With Blank Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top