Logic Function Overview

IF

Performs conditional judgment and returns one value if the condition is true and another value if the condition is false.

AND

Evaluates a series of conditions and returns true only if all conditions are true.

OR

Evaluates a series of conditions and returns true if at least one condition is true.

SWITCH

Evaluates an expression and returns a corresponding result based on the first matching value.