The MAX and MIN functions immediately returns the maximum and minimum values for the specified range.

But sometimes there is a need of including logical values along with numeric values to find out max and min value, then MAXA and MINA functions are very helpful.

The syntax of theses functions are same and takes only one argument which either be number or location of data range.

In this post we will using a simple example to demonstrate the core usage of these functions.

It will yield the maximum value from the field Marks, as shown in the screenshot below.

The syntax of these functions are absolutely same as MAX and MIN function, the primary difference is that it is able to consider logical values as number (TRUE as 1 and FALSE as 0).

Column C has values I just typed in fresh, and the Median function is working fine.

Im guessing theres something embedded in these cells that makes the Median function not work, but I cant find it.

Ive tried the copy and paste value feature to try to eliminate whatever is in these cells, but no luck.

As I uploaded it, the formula in Column A returns a value of 87.

Last night, when I sorted the data from smallest to largest, the value changed (which shouldnt happen with a Median function).

Today, I cannot reproduce that particular error, but the Median for column A should be 21, not 87.

Now Im noticing that if I change the last value in column C to 10, the Median formula result changes to 6.

My understanding of Median is that, if you have an odd number of numbers, Median is just the number in the middle when you sort them by highest to lowest.

Changing the largest number to a larger number, shouldnt affect Median, by my understanding.

How To Find The Median On Excel For Mac