Established spreadsheet shows err for errors for div/0
 

In general:

=IF(ISERROR(Your Formula),"",Your Formula)

But of course it's better to prevent the errors:

=IF(A2=0,"",A1/A2)

--
Regards,

Niek Otten
Microsoft MVP - Excel

"Chris Sergent" wrote in message
...
I am so novice at programming in MS Excel.

However,
I have an Excel spreadsheet with a great deal of formulas
on it. Is there a way to either globally suppress errors
on an Excel spreadsheet. If not, what code could be
written to check the current spreadsheet for any cells
that produce an error, to show up as "" without actually
changing the formula that already exists. Because all of
the formulas are different, a find and replace will not
work.

I appreciate any help. Thanks.

Chris