Operand without an operator error

[Thompyt]

Test: IIf([Level]="Level 3 Cat II" Or [Soft Level]="Level 3 Cat II" And [HR]<>0,“GO OOB in Progress”,"Nope")



I get this error on the OOB part of the code. I thought this was a simple IIF(Condition, True Statement, False Statement) code.

Any suggestions?

Thanks

[Thompyt]

Figured it out, it was in the " (Text) and “ (Word).

[June7]

Be careful when mixing OR and AND operators. Parens can be critical. Maybe should be:

IIf(([Level]="Level 3 Cat II" Or [Soft Level]="Level 3 Cat II") And [HR]<>0,

or

IIf([Level]="Level 3 Cat II" Or ([Soft Level]="Level 3 Cat II" And [HR]<>0),

Without parens I think the first structure will be invoked.

And this would be very different output:

IIf([HR]<> 0 AND [Level]="Level 3 Cat II" Or [Soft Level]="Level 3 Cat II",

[Thompyt]

Thanks June7, Fortunately I already picked up on it when I added a True/False control and it wouldn't recognize. Added () around the OR controls and then it worked.