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