Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding cell information
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding cell information
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. "Rescueme" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding cell information
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding cell information
"Rescueme" wrote in message
... 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_D ata'!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) -- David Biddulph |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding cell information
Thank you Pete I have success and have the spreadsheet working
"Pete_UK" wrote: 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding 1 cell | Excel Discussion (Misc queries) | |||
Viewing information after hiding columns / rows | Excel Discussion (Misc queries) | |||
Viewing information after hiding columns / rows | Excel Discussion (Misc queries) | |||
hiding the cell and the formula bar | Excel Discussion (Misc queries) | |||
Hiding "Send To Mail Recipient" Information In Excel | Excel Discussion (Misc queries) |