이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
MEDIAN(number1, [number2], …)The median is the number in the middle of a set of numbers. If the set contains an even number of values, the function returns the average of the two middle numbers.
=MEDIAN(1, 2, 3, 4, 5)결과: 3
The middle value in this set is 3.
=MEDIAN(10, 20, 30, 40)결과: 25
Since there are 4 numbers, it averages 20 and 30.
Empty cells, logical values, or text in references are ignored.