Find and IF statement

  • Thread starter Thread starter Atif
  • Start date Start date
A

Atif

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",""))
 
Atif said:
=IF(SEARCH("BCOT",A2)>0,"BCOT",IF(SEARCH("BCPN",A2)>0,"BCPN",""))
Click to expand...

Try:

=IF(ISNUMBER(SEARCH("BCOT",A2)),"BCOT",IF(ISNUMBER(SEARCH("BCPN",A2)),"BCPN",""))


----- original message -----
 
replace your formula with this one:

=IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR(SEARCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT")
 
Can we add more conditions?

cm said:
replace your formula with this one:

=IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR(SEARCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT")
Click to expand...
 
you can nest up to 7 if statements; if you need more conditions, there will
need to be a different solution.
 
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(ISERROR(FIND("BMTT",AO2)),"","BMTT"),"SCC"),"BCOT"),"WCC"),"MHO"),"YSC")
 
Back
Top