Apple Numbers '08 - Manual (Page 248)

248 Chapter 12 Dictionary of Functions
MAXA
The MAXA function finds the largest number in a set of values. In addition to numeric
values, text values and logical FALSE are counted as 0 and logical TRUE is counted as 1.
MAXA(value, [value, . . .])
 value: A series of numbers or numeric expressions, or references to cells containing
numbers, numeric expressions, text, or Boolean values.
Notes
Text entered directly in the arguments results in an error.
MEDIAN
The MEDIAN function finds the median value in a set of numbers. The median is the
“middle” value in the sense that half the numbers in the set are less than the median
and half are greater.
MEDIAN(number, [number, . . . ])
 number: A series of numbers, numeric expressions, or references to cells containing
numbers or numeric expressions.
Notes
If there is an even number of values in the set, the MEDIAN function returns the
average of the two middle values.
MID
The MID function extracts the specified number of characters from a string starting at
the specified position.
MID(text, start, length)
 text: A text expression.
 start: The number of the first character to extract. Position 1 is the first character in
the string.
 length: The number of characters to extract.
Examples
MAXA(1, 2, 3, 4) returns 4.
MAXA(A1:C1), where A1:C1 contains -1, -10, hello, returns 0.
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.