Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
OR – Test if any arguments are true
Overview
This Custom Field will return TRUE if any argument in a list of arguments is TRUE; it will return FALSE if all arguments are FALSE.
Syntax
OR(Argument1,Argument2)
| Element | Description |
|---|---|
| Argument1 | First argument to test. |
| Argument2 | Second argument to test. |
Example
OR(IF (FIELDSTR(Price), ‘>’, 10), IF (FIELDSTR(Availability),
‘=’, ‘TRUE’))
| PRICE | AVAILABILITY | OR(IF (FIELDSTR(Price), ‘>’, 10), IF (FIELDSTR(Availability), ‘=’, ‘TRUE’)) |
| 5.00 | TRUE | TRUE |
| 6.75 | FALSE | FALSE |
| 10.00 | TRUE | TRUE |
| 15.00 | TRUE | TRUE |
| 17.50 | FALSE | TRUE |
In this example, OR(IF (FIELDSTR(Price), ‘>’, 10), IF (FIELDSTR(Availability),
‘=’, ‘TRUE’)) tests to see if EITHER the price is greater than $10.00 OR if the Availability status is true. If ONE of the two arguments is true, a value of TRUE will be retrurned.
See also