Condition Functions

Use condition functions to decide between two or more actions depending on whether a logical expression is true or false.

Function

Description

CASE

Returns a result based on a series of conditions.

CHOOSE

Returns one of the values based on the first number.

IIF

Evaluates a condition and returns either value 1 or value 2.

Related Topics