Just for the record, in Excel 2007 you can use the new IFERROR function.
E.g.,

=IFERROR(x/y,"")

It will return x/y is no error occurs, or an empty string if an error
occurs.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"John Bundy" (remove) wrote in message
...
you can use an iserror such as
=IF(ISERROR(1/0),"",1/0)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"PATTO" wrote:

Is there a simple formula for displaying "0" as a result, not "#DIV/0!",
when
cells are intentionally left blank or contain "0" as a divisor ?
If so, how is it applied with a formula already in the cell?
Hope someone's got the answer..
thanks