September 18, 2020
With the MEDIAN function, you will be able to quickly return the median (middle number) in a given set of numbers. For example, =MEDIAN(1,2,3,4,5) returns 3. This ensures that outlying numbers do not sway the outcome when measuring a group of data, and in many cases, is a more accurate function than using AVERAGE. Learn more.