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.