A
Andy
Hi;
How do You do use the OR operator in an IIF expression?
IIF([Item]="Shirt" OR "Hat", "Sold","Not Sold")
Tried this from help:
OR
Returns TRUE if any argument is TRUE; returns FALSE if all arguments are
FALSE.
Syntax: OR(logical1,logical2, ...)
It doesn't work.
Somebody knows, would You share it?
Andy
How do You do use the OR operator in an IIF expression?
IIF([Item]="Shirt" OR "Hat", "Sold","Not Sold")
Tried this from help:
OR
Returns TRUE if any argument is TRUE; returns FALSE if all arguments are
FALSE.
Syntax: OR(logical1,logical2, ...)
It doesn't work.
Somebody knows, would You share it?
Andy