LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Hiding cell information

Yes. On how many cells of data does your formula depend?
If just 1 cell, then =IF(A2="","",your_formula)
If say 3 cells, then =IF(COUNT(A2:C2)=3,your_formula,"")
--
David Biddulph

"Rescueme" wrote in message
...
I am working in Excel 2003 with a spreadsheet that is being set up for a
full
year and data will be added on a weekly basis. I would like to put the
formulas in the spreadsheet for the full year and not have cells populate
with error messages due to the fact that the corresponding data has not
yet
been entered. In Excel there is a way to put a formula in a cell yet not
have
the cell populate with anything till the corresponding data is entered.



 
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
hiding 1 cell duckie Excel Discussion (Misc queries) 2 October 5th 07 03:18 PM
Viewing information after hiding columns / rows Annie Excel Discussion (Misc queries) 2 February 21st 07 03:36 PM
Viewing information after hiding columns / rows john Excel Discussion (Misc queries) 0 February 21st 07 02:11 PM
hiding the cell and the formula bar Lou Sanderson Excel Discussion (Misc queries) 2 October 18th 06 09:59 PM
Hiding "Send To Mail Recipient" Information In Excel SLorenson Excel Discussion (Misc queries) 2 September 14th 05 08:34 PM


All times are GMT +1. The time now is 01:34 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"