OR (||)

Description

The OR (||) operator tests whether one or both conditions are true.

Multiple OR expressions can be chained together to test whether one or more conditions in a set of conditions are true.

Usage

a || b
a || b || c
Argument Required Expected Type Description
a Yes Boolean The first condition
b Yes Boolean The second condition

Result

  • TRUE if one or both conditions evaluate to TRUE.
  • FALSE if both conditions are FALSE.
  • BLANK if both conditions are BLANK, or if one condition is BLANK and the other is FALSE
Next item
PIVOTLONGER