Help Please Formula Qestion

[georges3374]

Is there away to right this formula so it will not refers day 2 be for B31 =2. The problem I am having is day 2 dose not exist until B31=2. =IF(B31=1,0,IF(B31=2,'Day 2'!H11))

 

[InaCell]

What is the reference to 'Day 2'!H11. Is there a value in this cell?

Are you wanting the sheet to appear/be constructed when the B31 value = 2?

What you have presented does not explain what you are trying to achieve.

 

[antialias401]

=IF(B31=1,0,IF(B31=2,'Day 2'!H11))

That formula seems to be doing what you ask.
If B31 = 1, then it displays a "0"
If B31 = 2, then it displays the value in "Sheet Day 2, Cell H11"
If B31 does NOT equal 1 or 2, then it displays "False"

Do you want to change this behavior?

 

[georges3374]

The worksheet "Day 2" does not exist yet. It will be created at a later date along with Day 3, Day 4, Day 5, etc...The problem is I have a summary sheet that references sheets that are not yet created and I would like a formula that will not look any further than B31 if it is equal to 1. Is there something that I can do so it does not return an error?

 

[InaCell]

Try

=IFERROR(IF(B31=1,0,IF(B31=2,'Day 2'!H11,"")),0)

in a copy of your workbook.

Right result?

 

[georges3374]

No, when i enter that formula it still wants me to select the worksheet where "Day 2" is located even though it is in the same workbook.

 

[InaCell]

In 2007, that formula gives 0 when B31 = 1 or 2.

Gives a blank result = "" in all other instances, regardless if the sheet exists or not.

 

[antialias401]

No, when i enter that formula it still wants me to select the worksheet where "Day 2" is located even though it is in the same workbook.

If it asking you to open a workbook, then the spelling is off.
Check that the spelling in between the apostrophes is absolutely correct:
'Day 2' vs. 'Day2'

Currently, your formula has a space between Day & 2, make sure that is correct.

In 2007, that formula gives 0 when B31 = 1 or 2.
Gives a blank result = "" in all other instances, regardless if the sheet exists or not.

That is correct, but I think what OP is experiencing is that it will still prompt with an Open Dialog Box at formula insertion.
If Day2 does not exist, then when the open dialog box opens, you can hit cancel on the popup window to accept the formula without setting the Day 2 sheet.

 

[InaCell]

True, it will prompt the first time.

It will work OK after that.