OR

Try it

When to use it

When should I use OR instead of AND?

Use OR when any one condition being true is enough; use AND when every condition must be true.

How do I combine OR with IF?

Put OR inside the IF test, so the IF returns its true result when at least one of the OR conditions holds.

Use cases

Flag a value outside an allowed band

Approve when at least one rule passes

Used in

operations

Syntax

OR(value1,...)