Hiding cell information
Instead of =SUM(1100-'2008_Data'!B4), make this:
=IF('2008_Data'!B4="","",1100-'2008_Data'!B4)
Instead of =SUM('2008_Data'!C5-'2008_Data'!C4), change this to:
=IF(OR('2008_Data'!C5="",'2008_Data'!C4=""),"",'20 08_Data'!
C5-'2008_Data'!C4)
And instead of =SUM((F4*1000/D4)), amend this to:
=IF(OR(F4="",D4=0),"",F4*1000/D4)
You don't need SUM in any of the formulae.
Hope this helps.
Pete
On Dec 24, 5:00*pm, Rescueme
wrote:
David my information is coming from a seperate sheets in cells
'2008_Data'!B4:H4
Current formula in first cell is: =SUM(1100-'2008_Data'!B4) in this one I am
having 1100 show up as an answer in all cells.
in second cell is: =SUM('2008_Data'!C5-'2008_Data'!C4) - this type are
showing with a 0 value
in third cell is: =SUM((F4*1000/D4)) - her I get the standard error #DIV/0!
"David Biddulph" wrote:
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..- Hide quoted text -
- Show quoted text -
|