How to calculate maximum and minimum values

Let’s take a look.

Let’s calculate the maximum and minimum values in this list.

First, I’m going tocreate a named rangefor the prices in the list.

You don’t need to do this, but it makes the formulas easier to read and copy.

To get a maximum value, use theMAX function.

MAX takes one or more arguments, each representing a number or range of numbers.

In this case, we just need to supply the named range “prices.”

To get the minimum price in this list, we need to use theMIN function.

Like MAX, MIN takes one or more arguments.

As before, we just have to supply the named range “prices.”

Now we’ve calculated both a maximum and minimum price.

In that case, we’ll need some additional functions.

Let’s start with largest values.

Because we want more than just maximum, we need to use a function called LARGE.

you could think of k like “n” for “nth.”

The opposite of theLARGE functionis theSMALL functionwhich calculates the smallest values in a list.

Like LARGE, SMALL also has an argument called “k” that indicates position in the list.

In other words, the minimum value.