It appears to say :
= if a9 is cmt divs or fund (or J9 is blank) use ""
else (spare =) if (b9=1 ...do-this-thing,.... else , nothing))

where do-this-thing is (J9=0,"Stock not rated",IF(J9<3,"Sell - low
rating",""))

which doesn't make sense to me.


Micayla Bergen Wrote:
i dont know what i have too many of or not enough of in this equation
but
something is awry
=IF(OR(ISNUMBER(SEARCH({"cmt","divs","fund"},A9)), J9=""),"",=IF(B9=1,(J9=0,"Stock
not rated",IF(J9<3,"Sell - low rating","")),))
thanks anyone


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395224