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

#### G00DNESS

##### Board Regular
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

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Try something like this:

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

Last edited:
Try something like this:

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

I tried. Result: #VALUE

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

Try this:

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

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.

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.

You're very welcome.

Replies
4
Views
582
Replies
3
Views
651
Replies
2
Views
863
Replies
8
Views
341
Replies
1
Views
474

1,202,990
Messages
6,052,962
Members
444,622
Latest member
Kriszilla

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back