Formulas and Functions

MAX
The MAX function returns the largest number in a collection.
MAX(value, value…)
 value: A value. value can contain any value type.
 value…:Optionally include one or more additional values.
Usage Notes
If  value does not evaluate to a date or number, it is not included in the result.
To determine the largest of any type of value in a collection, use the MAXA function. Â
Examples
=MAX(5, 5, 5, 5, 6) returns 6.
=MAX(1, 2, 3, 4, 5) returns 5.
Related Topics
For related functions and additional information, see:
“LARGE” on page 264
“MAXA” on page 270
“MIN” on page 272
“SMALL” on page 288
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
MAXA
The MAXA function returns the largest number in a collection of values that may
include text and Boolean values.
MAXA(value, value…)
 value: A value. value can contain any value type.
 value…:Optionally include one or more additional values. All numeric values must
be of the same type. You cannot mix numbers, dates, and duration values.
270 Chapter 10 Statistical Functions