OMGGGGG Now I'm confused. Nested IF AND OR what?

[G00DNESS]

This is the scenario. I want a cell to return a value equaling 1 year more than Cell 'Year 1'!K1. However if 'Year 1'!K1 is empty the returned value should be blank. And if 'Year 1'!K1 equals "Year 1", return "Year 2. But if 'Year 1'!K1 is not blank and does not equal "Year 1", add (+1) to 'Year 1'!K1.

I'm in need of a formula that will factor in all of these: (somehow)
IF 'Year 1'!K1="",""
IF 'Year 1'!K1="Year 1","Year 2"
IF 'Year 1'!K1<>"Year 1" and if 'Year 1'!K1<>"Year 1",'Year 1'!K1+1

 

[bbott]

Try something like this:

=IF('Year 1'!K1="","","Year "&MID('Year 1'!K1,FIND(" ",'Year 1'!K1,1),3)+1)

 

[G00DNESS]

Try something like this:

=IF('Year 1'!K1="","","Year "&MID('Year 1'!K1,FIND(" ",'Year 1'!K1,1),3)+1)

I tried. Result: #VALUE

 

[bbott]

What is in K1 on the sheet named Year 1? And is that the exact name of the sheet (no other spaces, characters, etc)?

 

[bschwartz]

Try this:

=IF('Year 1'!K1<>"",IF('Year 1'!K1="Year 1","Year 2",'Year 1'!K1+1),"")

 

[G00DNESS]

What is in K1 on the sheet named Year 1? And is that the exact name of the sheet (no other spaces, characters, etc)?

It will contain a year. But if it is empty, that would be a problem.

 

[G00DNESS]

Try this:

=IF('Year 1'!K1<>"",IF('Year 1'!K1="Year 1","Year 2",'Year 1'!K1+1),"")

Thank you both! This was mind boggling. SMH now I can move forward.

 

[bschwartz]

You're very welcome.