Hi!

I see that you're using a SEARCH function in your formula. Does that mean
the cell contains more text than the specific substrings that you're looking
for?

If so:

=IF(OR(ISNUMBER(SEARCH({"transf","post","last"},C2 ))),"T",IF(OR(ISNUMBER(SEARCH({"fee","charge"},C2) )),"F","O"))

Biff

"STEVEB" wrote in
message ...

Hi,

Does anyone have any sugesstions for the following:

I have a formula that looks at a cell in Column C and if Column C
contains the text "transf: it wil put a "T" on column D, if not it will
put an "O" in Column D.

My formula is as follows:

=IF(ISERR(SEARCH("transf",C2)),"O","T")

I would like to expand the formula to include:

1) If C2 contains "transf" or "post" or "last" then put a "T" in column
D
2) If C2 Contains "fee" or "charge" then put an "f" in column D
3) If C2 does not contain anything above then put an "O" in column D


Any help would be greatly appreciated!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile:
http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=483301