ExcelBanter - How to tackle Division by zero for DAVERAGE function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to tackle Division by zero for DAVERAGE function (https://www.excelbanter.com/excel-worksheet-functions/57088-how-tackle-division-zero-daverage-function.html)

Sharma

How to tackle Division by zero for DAVERAGE function

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

Biff

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 "-"?

All times are GMT +1. The time now is 05:50 AM.