MIN Function
Returns the smallest value in a set of numbers. Ignores empty cells, text, and logical values.
ExcelGoogle Sheets
Syntax
MIN(number1, [number2], ...)Parameters
| Parameter | Description |
|---|---|
| number1 | The first number, cell reference, or range. |
| numberN(optional) | Additional numbers or ranges. |
Examples
Find the lowest price
=MIN(C2:C200)Result: 4.99
Find the earliest date
=MIN(A2:A100)Result: Returns the earliest date in the range
Tips & Best Practices
- •MIN ignores text and empty cells.
- •Use MINIFS for the smallest value meeting conditions (Excel 2019+/Google Sheets).
- •Combine with IF for conditional minimums in older Excel: {=MIN(IF(A2:A100="East", B2:B100))} (array formula).
Related Formulas
Need a different formula?
Describe what you need in plain English and our AI will generate the formula for you.
Try Formula Generator