Good to see, and thanks for the response.

Titian Wrote:[color=blue]
"Bryan Hessey" wrote in message


=IF(OR(AND(A2=1,B2<=10),AND(A2=2,B2<=20)),"Yes",IF (OR(AND(A2=1,B210),AND(A2=2,B220)),"No",""))


it works a treat.

cheers
Dan


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487142