You didn't say what you wanted if the formula evaluated as false so this one
returns Unspecified.

=IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" )

Mike

"TMF in MN" wrote:

a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!