Hiding a formula error

[Kim]

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

 

[Frank Kabel]

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

 

[Gord Dibben]

Kim

I don't understand why you would be getting #REF! error by just
referring/linking to an empty cell on another sheet.

You have something else going on. The cell or sheet reference is incorrect.

Gord Dibben Excel MVP