Adding CONTAINS in Formula

[JABWootton]

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

 

[Richard Schollar]

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]

Star
Thanks
Simple when you know how