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

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

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

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

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

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

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