Formulas and Functions

Chapter 10 Statistical Functions 271
Usage Notes
Text values and logical FALSE are given a value of 0 and logical TRUE is given a value Â
of 1.
To determine the largest value of a collection that contains only numbers or dates, Â
use the MAX function.
Examples
=MAXA(1, 2, 3, 4) returns 4.
=MAXA(A1:C1), where A1:C1 contains -1, -10, hello, returns 0.
Related Topics
For related functions and additional information, see:
“MAX” on page 270
“MINA” on page 273
“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
MEDIAN
The MEDIAN function returns the median value in a collection of numbers. The median
is the value where half the numbers in the set are less than the median and half are
greater.
MEDIAN(num-date-dur, num-date-dur…)
 num-date-dur: A value. num-date-dur is a number value, a date/time value, or a
duration value.
 num-date-dur…:Optionally include one or more additional values. If more than
one num-date-dur value is specied, all must be of the same type.
Usage Notes
If there is an even number of values in the set, the MEDIAN function returns the Â
average of the two middle values.