What does the MEDIAN function do in Excel?

Answer 1

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.

Answer 2

The median is a form of average. It finds the middle value of the list of values in numerical order if there is an odd number of values. If there is an even number of values, if uses the value halfway between the two middle values.