Apple numbers User Manual

    Dictionary of Functions 

 

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.
  

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.
  

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.

MAXA(1, 2, 3, 4) returns 4.

MAXA(A1:C1), where A1:C1 contains -1, -10, hello, returns 0.

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.