OR
Returns true, if one of the arguments is true and returns false if both arguments are false. It takes in two arguments and both are required. To evaluate more than two logical expressions at a time, you can nest multiple Or functions (see examples below).
Syntax: OR (
logical_expression_1
,
logical_expression_2
)
logical_expression_1
is the first logical test or expression or boolean value (true, false)logical_expression_2
is the second logical test or expression or boolean value
Example: OR ( true , true )
Output: true
Example: IF ( OR ( AND ( 1 > 2 , 2 < 3 ) , 1 == 1 ) , 30 , 40 )
Output: 30
Last updated
Was this helpful?