IF statement with AND & OR criterias

[DarkoDeign2]

Hi,
I have an issue with this formula and I can't get it to work, what is wrong? Tried searching but couldn't get anything to help me solve this.

=IF(OR(Y2="Stop", AND(V2=0, Y2="Start"), V2+7, ))

I have the above formula in Column "X"
In Column "V" I have dates, or the cell could be blank
In Column "Y" I could have the text "Stop", "Start" or the cell could be blank

If V2 is blank, then ""
If Y2 contains the word stop, then ""
If Y2 contains the word start, then ""
If V2 contains a date, then V2+7 in cell X2

 

[DarkoDeign2]

Sorry the formula is:

=IF(OR(Y2="Stop", AND(V2=0, Y2="Start"), V2+7, "" ))

 

[kevin9999]

If V2 is blank, then ""
If Y2 contains the word stop, then ""
If Y2 contains the word start, then ""
If V2 contains a date, then V2+7 in cell X2

Which conditions do you want to take precedence, the 2 conditions in cell V2 or the 2 conditions in cell Y2?

 

[DarkoDeign2]

I would say the 2 conditions in cell Y2

 

[kevin9999]

Experiment with this & see if it gives you what you want:

Book1
	V	W	X	Y
1
2
3
Sheet1

Cell Formulas
Range	Formula
X2	X2	=IF(OR(Y2="stop",Y2="start"),"",IF(V2="","",V2+7))

 

[DarkoDeign2]

Thanks a lot Kevin!!

 

[kevin9999]

Thanks a lot Kevin!!

You're welcome

 

[DarkoDeign2]

I just thought of simplifying the formula.
What if the criterias are:

If V2 contains a date and Y2 is blank, then add V2+7 in cell X2

How would that formula look like?

 

[kevin9999]

If V2 contains a date and Y2 is blank

What would you want to happen if V2 had a date but Y2 isn't blank?

 

[DarkoDeign2]

Then I would like to in cell X2, add V2+7, othervise ""