LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kim
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL ERROR - series formula is too long BobY Excel Worksheet Functions 3 April 3rd 23 10:55 AM
Formula Error Mike R Excel Discussion (Misc queries) 6 January 15th 05 05:27 AM
Error in a formula imej-clavier Excel Discussion (Misc queries) 1 December 17th 04 04:07 PM
Formula Error Cheri Excel Discussion (Misc queries) 3 December 14th 04 12:01 AM
Formula error Chris Excel Worksheet Functions 0 November 17th 04 05:08 PM


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"