formula meeting certain criteria including "contains&qu

[JABWootton]

i am trying to get a formula to work which has the following
if B10 =y and L10 has a date in it and C10 contains the letters GCD then add 180 to L10
have so far got
=IF(AND($B10="Y",ISNUMBER($L10)),$L10+180,"")
but cannot add to the formula to add Contains GCD in Cell C10
Any Help Appreciated

 

[Joe4]

Try this:
=IF(AND($B10="Y",ISNUMBER($L10),NOT(ISERROR(FIND("GCD",$C10,1)))),$L10+180,"")

 

[JABWootton]

Perfect
Thank You