Try Something like this
=IF(AND(C19=Criteria!H4,C8Criteria!H11,C22=Crit eria!H18),"","LLLLLL")

If the below values are always the same you could simplify matters by
putting
=IF(AND(C19=1,C815,C224.5),"","LLLLLL")
Current Ration must be at least 1
Return on Shareholders funds exceeds 15% and
Dividend Yield exceeds 4.5%

let me know how it goes


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