Examples

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...] )

Arguments

[value...] (any): A series of zero or more values, separated by commas. Every value must be of a comparable type (e.g., all numeric, or all textual).

Return Value

A List comprised of the given values in the order given.

See Also

ANY(), CONCATENATE(), COUNT(), IN(), INDEX(), INTERSECT(), MAX(), MIN(), SORT(), SPLIT(), TOP(), UNIQUE()

Did this answer your question?