Hiding a formula error
 

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

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

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

On Tue, 30 Nov 2004 20:38:23 +0100, "Frank Kabel"
wrote:

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