The MEDIAN function
Returns the median of the given numbers. The median is the number in the middle of a set of numbers.
=median(2,3,4) return 3
- Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want the median.