I have some Investment Criteria that must be meet if I am to invest in
them.

the following must be meet to Invest

Current Ration must be at least 1
Return on Shareholders funds exceeds 15% and
Dividend Yield exceeds 4.5%

I would like an IF statment to tell me if any of these are not meet.


--
redlion
------------------------------------------------------------------------
redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140
View this thread: http://www.excelforum.com/showthread...hreadid=561904