If Function

[STEVEB]

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!

[Elkar]

Try this:

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

"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!
>
>
> --
> STEVEB
> ------------------------------------------------------------------------
> STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
> View this thread: http://www.excelforum.com/showthread...hreadid=483301
>
>

[Paul Sheppard]

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"))

[Biff]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

> =IF(OR(C2="transf",C2="post",C2="last"),"T",IF(OR(C2="fee",C2="charge"),"F","O"))

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

Biff

"Elkar" <[email protected]> wrote in message
news:[email protected]...
> Try this:
>
> =IF(OR(C2="transf",C2="post",C2="last"),"T",IF(OR(C2="fee",C2="charge"),"F","O"))
>
> "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!
>>
>>
>> --
>> STEVEB
>> ------------------------------------------------------------------------
>> STEVEB's Profile:
>> http://www.excelforum.com/member.php...fo&userid=1872
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=483301
>>
>>

[STEVEB]

Thank you to everyone for all your help!!!

The forulma worked great!! I appreciate all your help!