Formulas and Functions

Examples
=MEDIAN(1, 2, 3, 4, 5) returns 3.
=MEDIAN(1, 2, 3, 4, 5, 6) returns 3.5.
=MEDIAN(5, 5, 5, 5, 6) returns 5.
Related Topics
For related functions and additional information, see:
“AVERAGE” on page 231
“MODE” on page 274
“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
MIN
The MIN function returns the smallest number in a collection.
MIN(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 smallest of any type of value in a collection, use the MINA Â
function.
Examples
=MIN(5, 5, 5, 5, 6) returns 5.
=MIN(1, 2, 3, 4, 5) returns 1.
Related Topics
For related functions and additional information, see:
“LARGE” on page 264
“MAX” on page 270
272 Chapter 10 Statistical Functions