blank instead of DIV/0!

[bill gras]

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

 

[Biff]

Hi!

Here's one way:

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

Biff

 

[Guest]

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