it came back as blank for all of the lines even when it shouldnt have

"Max" wrote:

Try this rectification. But you have to test whether it returns correctly
based on your test values / expected returns

=IF(OR(ISNUMBER(SEARCH({"cmt","divs","fund"},A9)), J9=""),"",IF(OR(B9=1,J9=0)
,"Stock not rated",IF(J9<3,"Sell - low rating","")))

The error was in this part: .. =IF(B9=1,(J9=0, ..
which was rectified (with some guesswork) to read as:
.... IF(OR(B9=1,J9=0) ...
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Micayla Bergen" wrote in message
...
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