Another IF or COUNT

[thebigtable]

I need a range of A15:C15 to meet 2 crireria before I have a date formula put in J15
A15 criteria is "SPX" or "GP"
C15 criteria is 1,2 or 3
My date formula is H15,-21 (a date in H15 minus 21 days)
Can anyone assist?

J@thebigtable

 

[Aladin Akyurek]

I need a range of A15:C15 to meet 2 crireria before I have a date formula put in J15
A15 criteria is "SPX" or "GP"
C15 criteria is 1,2 or 3
My date formula is H15,-21 (a date in H15 minus 21 days)
Can anyone assist?

J@thebigtable

Something like?...

=IF(OR(A15={"SP","GP"}),IF(OR(C15={1,2,3}),H15-21,0),0)

 

[thebigtable]

How do I have nothing displayed if the criteria is not met. I want no date if the criteria is not met.

;>)

 

[thebigtable]

I think this will work.

=IF(OR(A15={"SPX","GP"}),IF(OR(C15={1,2,3,"SEN","HSS","PS","YS"}),H15-21," ")," ")

Thanks for your help Aladin.
Cheers,
J @thebigtable

 

[Scott Huish]

Change your " " to "" to return blank