LIST()

New list

Returns a new list of values in the order specified.

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

  • [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()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false