View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

One way:

=IF(AND(A1=1,OR(B1={3,4,5,6})),"OK","NOT OK")

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to create a formula as follows
IF cell x = 1, AND cell y=3, 4, 5, OR 6, then give me

answer of OK,
otherwise NOT OK
.