MEDIAN

Definition: MEDIAN is a function that returns the median value in a range of cells.

Syntax: =MEDIAN(number1, [number2], …)

Situation: This formula is appropriate when you need to find the median value in a range of cells.

Example: If you have a set of numbers 2, 4, 6, and 8, the median value can be found using the formula =MEDIAN(2, 4, 6, 8), which returns 5.