=IF(AND(D126<$I$1,G126="Bts D",G126="Bts
C",2,G126="Asda",G126="Wmm"),"1","")

How do you have a true and false for each option.

Bts D = 1 False = ""
Bts C = 2 False = ""
Asda = 3 False = ""
Wmm = 4 False = ""


--
timmadge
------------------------------------------------------------------------
timmadge's Profile: http://www.excelforum.com/member.php...o&userid=31266
View this thread: http://www.excelforum.com/showthread...hreadid=509389