I am using DAVERAGE function and teh resulkt is #DIV/0!. How to change this
display in a cell to blank or "-"?
I am using DAVERAGE function and teh resulkt is #DIV/0!. How to change this
display in a cell to blank or "-"?
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" <[email protected]> wrote in message
news:[email protected]...
>I am using DAVERAGE function and teh resulkt is #DIV/0!. How to change this
> display in a cell to blank or "-"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks