MEDIAN(number1, number2 [,number3])
Returns the median value in a list or array of numbers.
|number1||The first number.|
|number2||The second number.|
|number3||(Optional) The third number.|
|* The median is the middle of the distribution after the numbers have been sorted into ascending order.|
* If there is an odd number of unique numbers in the set, then the number in the middle is returned. See Example 1.
* If there is an even number of unique numbers in the set, then the average of the two numbers in the middle is calculated. See Example 2.
* The arguments can be values, cell references, arrays or named ranges.
* If any arguments evaluate to zero, they are included.
* If any arguments evaluate to True or False, then they are ignored.
* If any arguments contain text, then #VALUE! is returned. Example 21.
* If any cell references contain text, then they are ignored. See Example 13.
* If any cell references are empty, then they are ignored.
* You can have a maximum of 255 arguments.
* You can use the MEDIANIF function to return the median value in a range of values that match a certain condition.
* You can use the AVERAGE function to return the arithmetic mean of a list of numbers.
* You can use the MODE.SNGL function to return the value that occurs most frequently.
* For the Microsoft documentation refer to support.office.com
9 - Using curly brackets to define an array of items is optional and is not related to pressing (Ctrl + Shift + Enter).
© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited Top