Home › Practice questions › MIN › Question 9

Excel MIN Practice Question: Days late are in B2:B7. The late fee is 25 for each day late, but never more…

By Rinkesh Shah, founder of Cellgrids.

The question

Days late are in B2:B7. The late fee is 25 for each day late, but never more than 500. Show the fee in D2:D7.

The data

	A	B	D
1	Invoice	Days late	Late fee
2	INV-701	0	?
3	INV-702	3	?
4	INV-703	8	?
5	INV-704	15	?
6	INV-705	30	?
7	INV-706	45	?

The yellow cells are where your answer goes.

Show answer

Expected results:

D2 = 0
D3 = 75
D4 = 200
D5 = 375
D6 = 500
D7 = 500

How it works

Explanation: MIN returns the smaller of the calculated fee and the cap of 500, so the fee can never go above the limit.
Syntax: =MIN(B2*25,500)
8 days = 200. 15 days = 375. 30 days would be 750, but it is capped at 500.

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.