Hiding cell information

  • Thread starter Thread starter Rescueme
  • Start date Start date
R

Rescueme

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.
 
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,"")
 
I should have also noted that there is a formula already in each cell ex.
=SUM((F4*1000/D4)) - this one is producing an error #DIV/0! as the cells on
the next worksheet are not populated. Other cells are populating with 0 due
to no data.
 
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!
 
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=""),"",'2008_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
 
Rescueme said:
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 every case *please* get rid of the unnecessary SUM() function. Look in
Excel help at what SUM() does. It takes a list of separate arguments and
adds them together. You don't have a list of separate arguments that you
want to add together, so you don't want the SUM function.

=IF('2008_Data'!B4="","",1100-'2008_Data'!B4)
in second cell is: =SUM('2008_Data'!C5-'2008_Data'!C4) - this type are
showing with a 0 value
=IF(COUNT('2008_Data'!C5,'2008_Data'!C4)=2,'2008_Data'!C5-'2008_Data'!C4,"")

in third cell is: =SUM((F4*1000/D4)) - her I get the standard error
#DIV/0!

=IF(OR(D4=0,F4=""),"",F4*1000/D4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top