You can use the OR function to add the other scenarios.
=(IF(OR(K16="1 of 4",K16="5 of
10",K16=0.25),IF(I1660,"0",(IF(I16<11,"2",IF(I16 10,"1","2") ))),0))
Does that help?
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=515508