Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If Function
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 |
#2
|
|||
|
|||
If Function
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 |
#3
|
|||
|
|||
If Function
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 |
#4
|
|||
|
|||
If Function
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 |
#5
|
|||
|
|||
If Function
=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" wrote in message ... 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 |
#6
|
|||
|
|||
If Function
Thank you to everyone for all your help!!! The forulma worked great!! I appreciate all your help! -- STEVEB ------------------------------------------------------------------------ STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872 View this thread: http://www.excelforum.com/showthread...hreadid=483301 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |