Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
MIN
MIN scans one or more ranges and returns the lowest number found, ignoring text and empty cells. Use it to identify the minimum bid, lowest temperature, earliest date, or smallest measurement in a dataset.
Excel
=MIN(B2:B5)Google Sheets
=MIN(B2:B5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Product | Price |
| Alpha | 29.99 |
| Beta | 14.50 |
| Gamma | 44.00 |
| Delta | 9.99 |
=MIN(B2:B5)→9.99
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Reference the range to search: =MIN(B2:B5).
- 2MIN ignores text, blanks, and logical values.
- 3Returns the single smallest numeric value found in the range.