LIST()

New 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()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu