Statistical FunctionsBeginner

MIN Function (Statistical)

The floor, and how close you came to it.

Task:

You are deciding whether to raise the reorder level on a fast-moving part. Put the lowest stock level of the week in B7.

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/3

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

  1. MIN Function (Statistical)

    The floor, and how close you came to it.

    CoreBeginner
  2. The lowest price that is not zero

    A zero meaning "no quote" should not win the cheapest-price contest.

    Intermediate
  3. MIN across a row: the best of three quotes

    The cheapest option for each line, read sideways.

    Beginner

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.

7 rows × 2 columns1 cell you fill in
AB
1DayStock at close
2Monday142
3Tuesday96
4Wednesday31
5Thursday88
6Friday117
7Lowest point
What this exercise teachesMay contain the answer

The week averaged 94.8 units in stock, which sounds perfectly comfortable. On Wednesday there were 31. The average hides the moment it nearly went wrong, and a reorder level has to be set against that moment rather than against the typical day.