Excel MIN Practice Question: January sales are in B2:B7 and February sales in C2:C7. Find the biggest drop…
The question
January sales are in B2:B7 and February sales in C2:C7. Find the biggest drop (the most negative change) from January to February for any single product. Put it in E2.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Jan | Feb | Result | |
| 2 | Pens | 1200 | 1350 | ? | |
| 3 | Books | 2400 | 2150 | ||
| 4 | Bags | 3100 | 3480 | ||
| 5 | Caps | 980 | 1120 | ||
| 6 | Mugs | 1750 | 1690 | ||
| 7 | Tote | 860 | 1180 |
The yellow cell is where your answer goes.
Show answer
Answer in E2: -250
How it works
Explanation: C2:C7-B2:B7 builds a list of 6 differences. MIN picks the lowest, which is the biggest fall.
Syntax: =SUMPRODUCT(MIN(C2:C7-B2:B7))
The differences are 150, -250, 380, 140, -60 and 320. The lowest is -250.
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.…
- A shop made a loss every month (B2:B7 show profit as negative numbers). Find the worst…
- 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…
- 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