Quick Answer
MIN Function
MIN finds the lowest value in a range.
✓ Excel✓ Google SheetsExcel All versions
Syntax
MIN
(number1, [number2], ...)
Parameters
| Parameter | Description | Required |
|---|---|---|
| number1 | The first number, cell reference, or range. | Required |
| number2 | Optional additional numbers, cell references, or ranges. | Optional |
Basic Example
Find the lowest value in a range
=MIN(A1:A10)Result25
Returns the smallest number from cells A1 through A10.
Advanced Examples
Example 1: Min with criteria using MINIFS
Conditional minimumFind the minimum value that meets specific criteria
=MINIFS(A1:A10, B1:B10, "Region A")Result: 32
MINIFS finds the lowest value in column A where column B matches "Region A".
How MIN Works
MIN scans all numeric values in the specified range and returns the smallest one, ignoring text, blank cells, and logical values.
1
Select output cell
Choose where the result should appear.
2
Enter formula
Type =MIN(range).
3
Press Enter
The result shows the minimum value.
Important Notes & Limitations
MIN ignores text and blank cells.
For conditional minimums, use MINIFS.
Common Errors & Fixes
#VALUE!No numeric values foundFix: Check your data range contains numbers.
Download Practice File
MIN
minPractice MIN with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the MIN function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Frequently Asked Questions
Does MIN consider dates?
Yes, dates are stored as serial numbers, so MIN can find the earliest date.