Find the minimum value

Beginner

When you're reviewing a budget, one of the fastest checks is to spot the smallest cost line. Excel can do this instantly.

The MIN function returns the smallest number in a list or range.

For example:

=MIN(10, 4, 25) returns 4

What you need to do

  1. Click cell C9 (the cell next to "Lowest expense:").
  2. Type a formula that returns the minimum value in the range C2:C7.
  3. Press Enter to calculate the lowest expense amount.

Goal

Cell C9 should show the lowest value from the budget amounts in column C.

Need some help?

Hint 1

The amounts you need are in column C, from row 2 through row 7.

Hint 2

Start your formula with =MIN( and then select the amount range before closing the parenthesis ).

Related function(s)

Exercise