You don't need to do this, but it makes the formulas easier to read and copy. Let's calculate the maximum and minimum values in this list.įirst, I'm going to create a named range for the prices in the list. Here we have a list of properties, that includes an address, a price, and a variety of other information. In this video we'll look at how to calculate minimum and maximum values in Excel.
