Formulas and Functions
ਇਸ ਕੰਟਰੋਲ ਦੀ ਸੋਧ ਕਰਨ ਨਾਲ ਇਹ ਪੰਨਾ ਆਪਣੇ ਆਪ ਅੱਪਡੇਟ ਹੋ ਜਾਵੇਗਾ

MEDIAN

The MEDIAN function returns the median value in a set of numbers. The median is the value where half the values in the set are less than the median and half are greater.

MEDIAN(value, value…)

value: Any value or collection. Date/time values or duration values can’t be mixed with other value types. If either of these value types is included, all values must be of the same value type. A string value or Boolean value can be included in a referenced cell, but can’t be entered directly as an argument to the function.

value…: Optionally include one or more additional values or collections.

Notes

  • A string value or Boolean value included in a referenced cell is not considered in determining which value is the maximum value.

  • If there is an even number of values in the set, the MEDIAN function returns the average of the two middle values.

Examples

=MEDIAN(1, 2, 3, 4, 5) returns 3.

=MEDIAN(1, 2, 3, 4, 5, 6) returns 3.5.

=MEDIAN(5, 5, 5, 5, 6) returns 5.

See alsoAVERAGEMODE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ਕੋਈ ਮਦਦ ਮਿਲੀ?
ਅੱਖਰ ਸੀਮਾ: 250
ਵੱਧ ਤੋਂ ਵੱਧ ਅੱਖਰ ਸੀਮਾ 250 ਹੈ
ਫ਼ੀਡਬੈਕ ਲਈ ਤੁਹਾਡਾ ਧੰਨਵਾਦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.