Quick Navigation
MIN Function
Summary
The Excel MIN function returns the smallest numeric value from a set of numbers, ranges, or arrays. It's essential for finding minimum values in datasets for statistical analysis, performance tracking, and data validation.
Syntax
MIN(number1, [number2], ...)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number1 | Number/Reference |
Yes | Required. The first number or range to evaluate |
| [number2] | Number/Reference |
No | Optional. Up to 254 additional numbers or ranges |
Using the MIN Function
MIN is perfect for quickly identifying the lowest value in sales data, temperatures, scores, or any numeric dataset. Use it standalone or combine with other functions for conditional minimums.
Common MIN Examples
Basic Range Minimum
=MIN(A2:A10)Returns the smallest value from cells A2 through A10.
Multiple Values
=MIN(15, 23, 8, 42, 3)Returns 3, the smallest number in the list.
With Constant
=MIN(B2:B20, 0)Finds minimum in range B2:B20 or 0 if all values higher.
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Arguments contain error values or unconvertible text
Solution: Remove error cells or use IFERROR wrapper
Unexpected results
Cause: Including text mistaken as numbers
Solution: Use MINA for text numbers or clean data
Notes
- Only numbers count from ranges - ignores blanks, text, logicals
- Direct logicals/text numbers in arguments ARE counted
- Maximum 255 arguments total
- Use MINIFS for criteria-based minimums
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+