Excel MAX 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 best month's result, which is the smallest loss. 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: -2700
How it works
Explanation: With negative numbers, MAX gives the one closest to zero.
Syntax: =MAX(B2:B7)
The closest to zero is -2700.
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 →MAX syntax
=MAX(number1, [number2], ...)
Returns the largest number in a set. MAX is used in data analysis work to summarize or test patterns across a data set. Full MAX guide.
More MAX practice questions
- A sales team's monthly sales are in B2:B8. Find the highest sale. Put it in D2.
- The daily temperature (in °C) for a week is in B2:B8. What was the hottest day's…
- Q1 sales are in B2:B6 and Q2 sales are in C2:C6. Find the single highest figure across…
- Exam marks are in B2:B8. Two students were Absent (typed as text). Find the top mark.…
- Invoice dates are stored as date numbers in B2:B6. Find the date number of the latest…
- Using the sales in B2:B8, show Meera's sales (B4) as a fraction of the best sale. Round…
- January sales are in B2:B7 and February sales in C2:C7. Find the biggest increase from…
- Daily sales for one week are in B2:B8. Find the highest sales figure of the week. Put it…
All practice questions · Excel exercises · Interview prep · Cheat sheet