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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
How do I make #DIV/0! error message go away? 2
Need to average data if in cells, but ignore blank cells. 4
Ignoring Blank cells 9
#DIV/0! ERROR 2
Supress DIV/0 2
How do I average cells that contain #DIV/01? 2
Average IF Function 3

Top