Hi
try
=IF(ISERROR(your_formula),"",your_formula)

--
Regards
Frank Kabel
Frankfurt, Germany

"Kim" schrieb im Newsbeitrag
...
Hello,
I have a worksheet that is a "total" sheet for 2 other worksheets.

I put the formula = then reference the other worksheet specific cell.
I
will not fill in the 2nd sheet for 2 weeks. On the total sheet is
shows as
#REF!.

How can I hide that #REF! until the 2nd sheet is filled in?

Thanks
--
Kim