How do I use MIN in Excel?
Use MIN when you want to find the lowest value. Enter Target range in that order, then add optional arguments when needed.
Excel Function
MIN
Returns the smallest value.
MIN(number1, [number2], ...)Arguments
number1
RequiredSpecify the first number or range to calculate.
Practice Preview
Use MIN to return the minimum value in Sales in column D. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=MIN(D2:D8)Result
250
Practice This Function
MIN FAQ
Where can I practice MIN?
Use the "Start Function Practice" button to jump straight into MIN drills.
What arguments does MIN use?
The main arguments are Target range. Enter them in order.