Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I perform a contains function for a specific cell?
I am wanting to do an if statement. If cell A contains "a certain word" then
Y else N. what is the syntax for the the contains portain of the if statement? |
#2
|
|||
|
|||
Vstein wrote:
I am wanting to do an if statement. If cell A contains "a certain word" then Y else N. what is the syntax for the the contains portain of the if statement? Some example idioms... =ISNUMBER(SEARCH(" "&E2&" "," "&A2&" "))+0 =ISNUMBER(FIND(" "&E2&" "," "&A2&" "))+0 =COUNTIF(A2,"*"&E2&"*") Custom format the formula cell as: [=0]"N";[=1]"Y" |
#3
|
|||
|
|||
Hi,
Try these: case sensitive =IF(ISERROR(FIND("YourString",A1)),"No","Yes") =IF(SUBSTITUTE(A1,"YourString","")=A1,"No","Yes") not case sensitive: =IF(COUNTIF(A1,"*YourString*"),"Yes","No") =IF(ISERROR(SEARCH("YourString",A1)),"No","Yes") Regards, KL "Vstein" wrote in message ... I am wanting to do an if statement. If cell A contains "a certain word" then Y else N. what is the syntax for the the contains portain of the if statement? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
How do I perform a "Countif" function for Two Columns? | Excel Worksheet Functions |