IIf - AND - IN

[Minkowski]

Hello everyone
i can't find out how to do this
and it seems so simple, i am going mental here
please help me out

if Order is different than zero and at the same time we have in Status Open or Close give me 1
Else (example <>0 and "Waiting" give me 0) or (zero and "Closed give me 0)

Expr1: IIf([Orders]<>0 And [STATUS] In ("Closed","Open"),1,0)

Or

Expr2: IIf(([Orders]<>0 And [STATUS]="Closed") Or ([Orders]<>0 And [STATUS]="Open"),1,0)

thanks in advance!

 

[james_lankford]

Expr2: 
IIf
(
  (
    [Orders] <> 0 
    And 
    (
      [STATUS] = "Closed" 
      Or 
      [STATUS] = "Open"
    )
  )
  ,1
  ,0
)

 

[Minkowski]

thank you very much!!