All functions / Logical

OR

TRUE if at least one condition is TRUE.

Syntax

=OR(logical1, [logical2], …)

Arguments

• logical: Conditions to test.

Example

=OR(B2="VIP", C2>1000) → TRUE when either holds

Practise it

• AND, OR and NOT
• Spotting problems with IS functions