Linking multiple IF funtions.

I have a list of stocks in one column and I am trying to categorize them.

Cells:
AAPL, INTC, QCOM
AAPL, QCOM
CHKP

These are 3 separate cells in the same column. I have a database of few hundred rows in this column to categorize.
I want to categorize each cell as either QCOM or CHKP depending on which ticker is included in the cell.
So far i'v beening writing a function of:
=if(search("QCOM",A2,1)>=1,"QCOM",IF(search("CHKP",A2,1)>=1,"CHKP","notfound"))

the issue is that when it is a QCOM cell, it works fine but when it is a CHKP cell, the first search function results in a #value error and thereby ending the function so it never gets to the second part (the false value of the first IF statement which activates the second IF statement)

any commentary and advice would be much appreciated.

Try it like this:

=if(ISNUMBER(search("QCOM",A2,1)),"QCOM",IF(ISNUMBER(search("CHKP",A2,1)),"CHKP","notfound"))

Hope this helps.

Pete

hey pete. I really appreciate the help but when you apply isnumber in this manner it only replies a "false" value which is interpreted as >=1 so even when i perform this on a CHKP cell, it simply fills it out as QCOM. Essentially, the first IF statement is regarded as value and always returns the true value under this construct.

Ok i figured it out. i changed the logical test to =true instead of >=1 thereby using the constrained values of the isnumber function. thanks so much for the help, I really appreciate it.

Works for me, as can be seen in the attached.

Pete

yup I see it works. my mistake. Always glad to learn mutiple new ways.

You don't need to have =TRUE in there, as that is implied.

Pete