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.


On Mon, 10 Jan 2005 12:01:03 -0800, Spunky
wrote:

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


"Don Guillett" wrote:

try
=IF(ISERR(FIND("dof",F11)),"",2)

--
Don Guillett
SalesAid Software

"Spunky" wrote in message
...
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.