Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
Hi:
I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
"Atif" wrote:
=IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) Try: =IF(ISNUMBER(SEARCH("BCOT",A2)),"BCOT",IF(ISNUMBER (SEARCH("BCPN",A2)),"BCPN","")) ----- original message ----- "Atif" wrote in message ... Hi: I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
replace your formula with this one:
=IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR(SEA RCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT") -- hope to help, cm "Atif" wrote: Hi: I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
Can we add more conditions?
"cm" wrote: replace your formula with this one: =IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR(SEA RCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT") -- hope to help, cm "Atif" wrote: Hi: I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
you can nest up to 7 if statements; if you need more conditions, there will
need to be a different solution. -- hope to help, cm "Atif" wrote: Can we add more conditions? "cm" wrote: replace your formula with this one: =IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR(SEA RCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT") -- hope to help, cm "Atif" wrote: Hi: I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
Yes, I need more conditions.
"cm" wrote: you can nest up to 7 if statements; if you need more conditions, there will need to be a different solution. -- hope to help, cm "Atif" wrote: Can we add more conditions? "cm" wrote: replace your formula with this one: =IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR(SEA RCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT") -- hope to help, cm "Atif" wrote: Hi: I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and IF statement
Thank you!
following statement worked for me: =IF(ISERROR(FIND("YSC",AO2)),IF(ISERROR(FIND("MHO" ,AO2)),IF(ISERROR(FIND("WCC",AO2)),IF(ISERROR(FIND ("BCOT",AO2)),IF(ISERROR(FIND("SCC",AO2)),IF(ISERR OR(FIND("BMTT",AO2)),"","BMTT"),"SCC"),"BCOT"),"WC C"),"MHO"),"YSC") "cm" wrote: you can nest up to 7 if statements; if you need more conditions, there will need to be a different solution. -- hope to help, cm "Atif" wrote: Can we add more conditions? "cm" wrote: replace your formula with this one: =IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR(SEA RCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT") -- hope to help, cm "Atif" wrote: Hi: I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error. any help. =IF(SEARCH("BCOT",A2)0,"BCOT",IF(SEARCH("BCPN",A2 )0,"BCPN","")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to find which sql statement is running? | Charts and Charting in Excel | |||
If statement to find NA() | Excel Worksheet Functions | |||
If statement to find NA() | Excel Worksheet Functions | |||
How do I use an if statement with Find and Replace | Excel Worksheet Functions | |||
Can't find logical_test for "if"statement | Excel Worksheet Functions |