How to Use the MIN Function in Excel

The MIN function quickly finds the lowest number in a large dataset.

Finding the Minimum Value

1. Click an empty cell and type =MIN(.
2. Highlight the range of numbers you want to evaluate (e.g., A1:A50).
3. Type a closing parenthesis ) and press Enter.
4. The cell will display the smallest number from that range.