Help with OR formula

  • Thread starter Thread starter itty
  • Start date Start date
I

itty

I have the following text in A1,A2 and formula in B1, B2.


WF-KIT-CITERNA
=IF(OR((SEARCH("KIT",A1)),(SEARCH("CY",A1)),(SEARCH("HY",A1))),"KIT","")



WF-KIT-CITERNA HY CY
=IF(OR((SEARCH("KIT",A2)),(SEARCH("CY",A2)),(SEARCH("HY",A2))),"KIT","")

B1 returns #value and B2 returns KIT. But If one of the abov
conditions satisfies I need KIT in B1. Can somebody tell me why i
returned value error and a solution for my problem.

Thanks in advance
Itt
 
Hi
try
=IF(OR(NOT(ISERROR(SEARCH("KIT",A1))),NOT(ISERROR(SEARCH("CY",A1))),NOT
(ISERROR(SEARCH("HY",A1)))),"KIT","")
 
Another way that avoids:
not(iserror(search()))

but uses:
isnumber(search())

=IF(OR(isnumber(SEARCH("KIT",A2)),
isnumber(SEARCH("CY",A2)),
isnumber(SEARCH("HY",A2))),"KIT","")

(all one cell)
 
Mr.Dave,
Goodmorning,
Formula which you gave with isnumber also worked.
Thanks a loooooooooooooot.....
Itt
 
Back
Top