Thursday, January 2, 2020

MEDIAN (Returns the median of the given numbers)















What Does It Do?
This function finds the median value of a group of values.
The median is not the average, it is the half way point where half the numbers in the group are larger than it and half the numbers are less than it.
If there is no exact median number in the group, the two nearest the half way point are added and their average is used as the median.
Syntax
=MEDIAN(Range1,Range2,Range3... through to Range30)
Formatting
No special formatting is needed.

No comments:

Post a Comment