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