How to tackle Division by zero for DAVERAGE function

G

Guest

I am using DAVERAGE function and teh resulkt is #DIV/0!. How to change this
display in a cell to blank or "-"?
 
B

Biff

Hi!

An AVERAGE(IF(........................) array formula would probably be
easier!

Try this:

=IF(ISERROR(your_formula)),"",your_formula)

That will return a blank. If you want the dash:

=IF(ISERROR(your_formula)),"-",your_formula)

Biff
 

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

#DIV/0! error with DAVERAGE Function 5
increment cell reference in a formula 3
daverage worksheet function 1
Reference cell values from other sheets in a function 2
daverage problems 3
daverage 1
Why do I get 0.00 for "" in a formula? 1
DAVERAGE, DMIN,etc from List 1

Top