Thread: How to tackle Division by zero for DAVERAGE function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default How to tackle Division by zero for DAVERAGE function
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

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


Reply With QuoteReply With Quote