Formulas and Functions

Value Type Description
list A list is a comma-separated sequence of other
values. For example, =CHOOSE(3, “1st”, “second”,
7, “last”). In some cases, the list is enclosed in
an additional set of parentheses. For example,
=AREAS((B1:B5, C10:C12)).
modal A modal value is a single value, often a number,
representing a specic mode for a modal
argument. “Modal argument” is dened in
“Syntax Elements and Terms Used In Function
Denitions” on page 34.
number A number value is a number, a numeric
expression, or a reference to a cell containing a
numeric expression. If the acceptable values of
a number are limited (for example, the number
must be greater than 0), this is included within
the argument description.
range value A range value is a reference to a single range of
cells (can be a single cell). A range value will have
an additional attribute dening the type of values
it should contain. This will be included within the
argument description.
38 Chapter 2 Overview of the iWork Functions