Maybe you can post some test data (what's does A9, J9 and B9 contain) for
those instances which return blank when it shouldn't be the case ..

Here's some clarifications on the returns by the rectified formula as it
stands (but remember that the rectification contains some guesswork as
stated)

If A9 is blank, B9 contains: 1, J9 is not blank,
result will be: Stock not rated

If A9 is blank, B9 does not contain: 1, J9 contains: 1 (or 2),
result will be: Sell - low rating

If A9 contains either: cmt, divs, funds, result will be: blank
(irrespective of what J9 or B9 may contain)

If J9 is blank (or contains a null string: ""), result will be: blank
(irrespective of what A9 or B9 may contain)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Micayla Bergen" wrote in message
...
it came back as blank for all of the lines even when it shouldnt have