View Single Post
  #3   Report Post  
Johannes
 
Posts: n/a
Default

cell x = A1
cell y = A2

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

depending on configuration use semi-colon instead of colon.

JP


"excel novice" <excel schreef in bericht
...
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