Formula Engine Reference Guide
 

 

Back to Class Index

 

MEDIAN(argumentlist)

Description
This function returns the median (middle value) of its arguments. Blank cells and cells containing strings are not counted.
 
Parameters
argumentlist
Any combination or numbers, cells or ranges
 
Examples
MEDIAN(A1..A6) = 80.5
where A1..A6 = 65, 70, 74, 87, 88, 95
 
MEDIAN(2, 8, 6, 5, 9) = 6