CONTAINS function (Excel 2002) | Windows Secrets Lounge

Is there a formula that will produce a result for "contains"... for example, I have an "IF" formula that reads a cell containing multiple words. I'd like the formula to say "IF" cell A3 "CONTAINS" the word "ACCRUAL", then the result in cell C3 is "YES". I

windowssecrets.com