Find the minimum value
BeginnerWhen 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
- Click cell C9 (the cell next to "Lowest expense:").
- Type a formula that returns the minimum value in the range C2:C7.
- 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?
Answer
Exercise
Find the minimum value
BeginnerWhen 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
- Click cell C9 (the cell next to "Lowest expense:").
- Type a formula that returns the minimum value in the range C2:C7.
- Press Enter to calculate the lowest expense amount.
Goal
Cell C9 should show the lowest value from the budget amounts in column C.