Basic FunctionsBeginner

MIN and MAX Functions

Find the minimum and maximum values in a dataset.

Task:

You are analyzing product prices to understand the price range. Find the minimum price in cell C8 and the maximum price in cell C9 to identify the lowest and highest priced items in your inventory.

Interactive Spreadsheet

Read about MIN, MAX

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of MIN, MAX

0/4

The same formula in the other shapes it takes at work.

  1. MIN and MAX Functions

    Find the minimum and maximum values in a dataset.

    CoreBeginner
  2. MINIFS and MAXIFS: the extremes of one group

    The cheapest and dearest option you can actually buy today.

    Intermediate
  3. The spread: MAX minus MIN

    How far apart the best and worst figures are, in one cell.

    Beginner
  4. Cap and floor a value with MIN and MAX

    MIN as a ceiling and MAX as a floor — the most common use of both at work.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

9 rows × 3 columns2 cells you fill in
ABC
1ProductCategoryPrice
2LaptopElectronics899
3PhoneElectronics599
4DeskFurniture299
5ChairFurniture149
6TabletElectronics399
7LampFurniture79
8Minimum Price
9Maximum Price

Functions used here

What this exercise teachesMay contain the answer

MIN and MAX functions are essential for finding extreme values in datasets.