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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999