A generic approach:

=IF(ISERROR(your formula),"",your formula)

If you post an example of your formula we might be able to suggest something
better.

--
Biff
Microsoft Excel MVP


"Kati" wrote in message
...
I am trying to create a workbook with multiple worksheets that utilizes
only
one data sheet and has the formulas already in place so that someone else
can
fill in just the hard data numbers and get the information out of the
formulas. Because it is for a at least a year and we only have 1 months
worth
of data, it is giving me =DIVD/0! errors. Can I hide the error message so
that the formula stays inside each cell but fills when the data sheet is
filled?
Thanks!