The MEDIAN function returns the content of the argument whose value is the middle value in the list formed by arranging the arguments in sorted order.
The function type is numeric.
___ Format _____________________________________________________________ | | | <____________ | | >>__FUNCTION MEDIAN__(____argument-1_|__)___________________________>< | | | |________________________________________________________________________|
The returned value is the content of argument-1 having the middle value in the list formed by arranging all argument-1 values in sorted order.
If the number of occurrences referenced by argument-1 is odd, the returned value is such that at least half of the occurrences referenced by argument-1 are greater than or equal to the returned value and at least half are less than or equal. If the number of occurrences referenced by argument-1 is even, the returned value is the arithmetic mean of the values referenced by the two middle occurrences.
The comparisons used to arrange the argument values in sorted order are made according to the rules for simple conditions. For more information, see "Conditional Expressions" in topic 6.1.6.
Adobe, the Adobe logo, Acrobat, the Acrobat logo, and Acrobat Reader are registered trademarks of Adobe Systems incorporated.