# Another IF or COUNT

#### thebigtable

##### New Member
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

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### Aladin Akyurek

##### MrExcel MVP
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

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

;>)

#### thebigtable

##### New Member
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

##### MrExcel MVP
Change your " " to "" to return blank

Replies
0
Views
149
Replies
11
Views
208
Replies
1
Views
139
Replies
27
Views
567
Replies
4
Views
330

Threads
1,191,032
Messages
5,984,238
Members
439,879
Latest member
KingGoulash

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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