#### JABWootton

##### Board Regular
have a formula which i need to add to the formula so that if certain letters are typed into the cell the formula calcualtes the date plus 180

Current Formula Which Works) is

=IF(AND(AND(AND(B12="Y",ISNUMBER(J12),(K12=1)+(K12=2)))),J12+180,"")

Need to add an entry where cell c12 CONTAINS the letter "GCD"
tried following but does not work

=IF(AND(AND(AND(B12="Y",(C12="* GCD *"),ISNUMBER(J12),(K12=1)+(K12=2)))),J12+180,"")

Help is appreciated

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

#### Richard Schollar

##### MrExcel MVP
Hi

You can use:

=ISNUMBER(SEARCH("GCD",C12))

for this, so:

=IF(AND(B12="Y",ISNUMBER(SEARCH("GCD",C12)),ISNUMBER(J12),OR((K12=1),(K12=2))),J12+180,"")

Best regards

Richard

#### JABWootton

##### Board Regular
Star
Thanks
Simple when you know how

Replies
3
Views
210
Replies
2
Views
227
Replies
4
Views
253
Replies
4
Views
333
Replies
1
Views
509

1,171,579
Messages
5,876,283
Members
433,192
Latest member
butterexcel

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