MEDIAN Function

The MEDIAN function is used to find the median of the given set of numbers. Median is nothing but the midpoint of the given values or quantities.
Note: If there is no exact median, the two nearest the half way point are added and their average is used as the median.

Formula:


=MEDIAN(Range 1, Range 2, Range 3,...up to Range 255)

Video Tutorial:


Let us find the median value of the given list, using the MEDIAN function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question