LIST()

Returns a new list of values in the order specified.

Sample usage

LIST(7, 4, 95) produces a list containing the three Number values. Equivalent to {7, 4, 95}.

LIST([Home], [Work], [Mobile]) produces a list of the Phone values in the given columns of the current row.

LIST() produces an empty list, useful in IF(), IFS(), or SWITCH() to return a blank value. See also: IF(), IFS(), SWITCH()

Syntax

LIST([value...])

• [value...] - Any value, separated by commas. Every value must be a comparable type (for example, all numeric or all textual).

See also

ANY()

CONCATENATE()

COUNT()

IN()

INDEX()

INTERSECT()

MAX()

MIN()

SORT()

SPLIT()

TOP()

UNIQUE()