Logic/Conditions

OR – Test if any arguments are true

274 views June 1, 2018 admin 0

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

 

 

Was this helpful?