ExcelBanter - blank instead of DIV/0!

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - blank instead of DIV/0! (https://www.excelbanter.com/excel-discussion-misc-queries/18495-blank-instead-div-0-a.html)

blank instead of DIV/0!

I have a formula like this =A1/COUNT(F3:F124)
When cells F3:F124 are emty, my formula returns #DIV/0!
Can that be made a blank cell instead of #DIV/0! ?

rgd Bill Gras

Hi!

Here's one way:

=IF(COUNT(F3:F124)=0,"",A1/COUNT(F3:F124))

Biff

-----Original Message-----
I have a formula like this =A1/COUNT(F3:F124)
When cells F3:F124 are emty, my formula returns #DIV/0!
Can that be made a blank cell instead of #DIV/0! ?

rgd Bill Gras
.

Try this one too.

(Assume Cell with formula is A1)

Go to 'Conditional Formatting' for this cell ,
In the condition box select th dropdown to make the selection 'Formula Is"
In the conditional format part type; =ISERROR(A1)
Now set the format to show the text as the same colour as the background.
Hey presto, your Div/0 error is hidden.

HTH

Neil
www.nwarwick.co.uk

"bill gras" wrote:

I have a formula like this =A1/COUNT(F3:F124)
When cells F3:F124 are emty, my formula returns #DIV/0!
Can that be made a blank cell instead of #DIV/0! ?

rgd Bill Gras