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