Excel MIN Practice Question: A shop made a loss every month (B2:B7 show profit as negative numbers). Find…
The question
A shop made a loss every month (B2:B7 show profit as negative numbers). Find the worst month's result. Put it in D2.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | Profit | Result | |
| 2 | Jan | -5200 | ? | |
| 3 | Feb | -3100 | ||
| 4 | Mar | -4800 | ||
| 5 | Apr | -2700 | ||
| 6 | May | -3900 | ||
| 7 | Jun | -6100 |
The yellow cell is where your answer goes.
Show answer
Answer in D2: -6100
How it works
Explanation: With negative numbers, MIN gives the biggest loss.
Syntax: =MIN(B2:B7)
The most negative number is -6100.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →MIN syntax
=MIN(number1, [number2], ...)
Returns the smallest number in a set. MIN is used in data analysis work to summarize or test patterns across a data set. Full MIN guide.
More MIN practice questions
- A sales team's monthly sales are in B2:B8. Find the lowest sale. Put it in D2.
- The daily temperature (in °C) for a week is in B2:B8. What was the coldest day's…
- Two suppliers' prices are in B2:B6 (Supplier A) and C2:C6 (Supplier B). Find the…
- Exam marks are in B2:B8. Two students were Absent (typed as text). Find the lowest mark.…
- Invoice dates are stored as date numbers in B2:B6. Find the date number of the earliest…
- Using the sales in B2:B8, find the gap between the best and the weakest sale. Put it in…
- January sales are in B2:B7 and February sales in C2:C7. Find the biggest drop (the most…
- Days late are in B2:B7. The late fee is 25 for each day late, but never more than 500.…
All practice questions · Excel exercises · Interview prep · Cheat sheet