=IF(AND(A11,A1<3),1,IF(A1<5,0<"You didn't say what happens when A1 =5"))

As I said, what about A1=5, and also A1=3

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Winnie" wrote in message
...
A1=2

How to set formual court If A11 and A1<3 = 1, If A13 and A1<5 =0