September 2011
Beginner
140 pages
3h 40m
English
The MEDIAN function returns the median of up to 30 given arguments separated with the semicolon sign (;). Each such argument may be a range of cells. For example, the following function
=MEDIAN(12.55; 10.93; 11.78; 12.00; 11.54; 12.67; 23.56; 45.21; 0.67)
returns 12.
If the number of arguments is even, then the mean of the two middle values is the median.
Figure 7-4. Sample result of the MEDIAN function
Read now
Unlock full access