How to combine two search formula's in to one with OR function

[Thinker8]

Hi All,


Formula 1 : =IF(SEARCH({"spinning"},A2),"AUTOGEN")

Formula 2 : =IF(SEARCH({"typing"},A2),"Manual")

I want to combine above two formula's with "OR" function.

please help me out on this.

Thanks in Advance

[Pete_UK]

I'm not sure why you've got the curly there, but try this:

=IF(ISNUMBER(SEARCH("spinning",A2)),"AUTOGEN",IF(ISNUMBER(SEARCH("typing",A2)),"Manual",""))

Hope this helps.

Pete

[vamosj]

Try this.


=IF(IFERROR(IF(SEARCH({"typing"},A2),"Manual"),"")="",(IF(IFERROR(IF(SEARCH({"spinning"},A2),"AUTOGEN"),"")="","",IF(SEARCH({"spinning"},A2),"AUTOGEN"))),IF(SEARCH({"typing"},A2),"Manual"))

[catchnanan]

hai thinker instead of combining with or u can use a simple if function like
=IF(A2="spinning","AUTOGEN","Manual")