MIN Function in Excel: Syntax, Examples and Free Practice
MIN is an Excel Statistical function. Returns the smallest number in a set.
MIN syntax
=MIN(number1, [number2], ...)
Arguments
number1: The first number or rangenumber2: An additional number or range (optional)
When to use MIN
MIN is used in data analysis work to summarize or test patterns across a data set.
Practice MIN online, free
Open the live Excel-style spreadsheet and try MIN yourself. No Excel install or sign-up needed to start.
Practice MIN now →Watch: MIN in Excel
Learn more
Read the tutorial: MAX, MIN, MEDIAN and MODE.
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…
- 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.…
More Statistical functions
Frequently asked questions
What does the MIN function do in Excel?
Returns the smallest number in a set.
What is the syntax of MIN in Excel?
The syntax is =MIN(number1, [number2], ...). number1: The first number or range; number2: An additional number or range (optional).
Where can I practice MIN online for free?
Open the free live spreadsheet on Cellgrids and try MIN yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts