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.

< All Topics
Print

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

IF

OR

NOT

 

 

Table of Contents