contrarian,

try in C6

IF(AND(B6B5,B6A5,B6<B4,B6<B3,B6<B2,B6<B1),"fish" ,"")

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=472085