next up previous contents index
Next: MESSAGE Up: A. Function Reference Previous: MDURATION   Contents   Index


MEDIAN

Syntax: MEDIAN(argumentlist)

argumentlist = any combination or numbers, cells or ranges

MEDIAN returns the median (middle value) of its arguments. Blank cells and cells containing strings are not counted.

Examples:

MEDIAN(A1..A6) = 80.5, where A1..A6 = 65, 70, 74, 87, 88, 95

MEDIAN(2, 8, 6, 5, 9) = 6

Excel function: MEDIAN


next up previous contents index
Next: MESSAGE Up: A. Function Reference Previous: MDURATION   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003