STEVEB Wrote:
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!
Hi steveb
Try this
=IF(OR(C8="transf",C8="post",C8="last"),"T",IF(OR( C8="charge",C8="fee"),"F","O"))
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=483301