If contains specific alpha

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The field may have a dash, comma, space or alpha. I want an IF statement
that will return a value if the field contains the letters DOF anywhere
within the field.
 
Didn't work, I made the adjustments for cell reference, it seemed to work but
it returned my value for true even in fields that did not contain DOF.

Exa. of cell contents:
ORDER FORM RTL-ACCENT
ECHOES DOF - SUMMER
 
1]

=COUNTIF(A1,"*DOF*")*10

would return 10 (a numeric return value) if CountIf successful, otherwise 0.

2]

=IF(COUNTIF(A1,"*DOF*"),ReturnVal,"")

would return the specified return value, otherwise nothing.
 
=IF(ISERR(FIND("DOF",G47)),"MKT",2)
Nope, still copies same text in every field down the column.
Appreciate your persistance.

Exa.:
MKT SOMEONE I LOVED DIED
MKT FAMILY R/P DOF - SUMMER
 
Find is case-sensitive. Your cell contains DOF, the formula dof. They
shouldn't match. For me they don't. The formula

=IF(ISERR(SEARCH("dof",F11)),"",2)

gives the correct results.
 
Back
Top