The MIN function in Excel returns the smallest number from a range of values. It is one of the most useful basic functions for identifying the lowest value in a dataset, such as the lowest sales amount, fastest time, smallest expense, or minimum score.
If you’re working with lists of numbers, the MIN function allows you to instantly locate the lowest value without manually scanning through data.
In this guide, you’ll learn:
- What the MIN function does
- How to write a MIN formula
- How to find the smallest value in a range
- How to use MIN with multiple ranges
- Common mistakes to avoid when using MIN
- Real-world examples of MIN in Excel
What Does the MIN Function Do?
The MIN function returns the smallest numeric value from a selected group of numbers.
For example:
If your data contains:
45, 72, 18, 90, 33
The MIN function returns:
18
This makes MIN extremely useful when you need to identify the lowest number in a dataset quickly and accurately.
MIN Function Syntax
The syntax for the MIN function is:
=MIN(number1, [number2], ...)
Argument Breakdown:
- number1 — The first number or range (required)
- number2 — Additional numbers or ranges (optional)
You can enter:
- Individual numbers
- Cell references
- Ranges
- Multiple ranges
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> MIN Function Data
Finding the Smallest Value in a Range
Let’s start with the most common use of MIN: finding the lowest number in a column.
Click on an empty cell (for example, A10)
Type:
=MIN(A2:A8)
Press Enter
Excel will return the smallest value from the selected range. In this case, 9.
Using MIN with Multiple Ranges
You can also calculate the smallest value across multiple ranges.
In B10 type:
=MIN(A2:A8, B2:B8)
Press Enter
Excel will return the smallest number found across both ranges. In this case, 7.
Ignoring Text and Blank Cells
The MIN function automatically ignores:
- Blank cells
- Text values
It only evaluates numeric values.
In cell C10 type:
=MIN(A2:A8)
Excel will return 18
Using MIN with Individual Numbers
You can enter numbers directly into the formula.
=MIN(45, 12, 78, 3, 29)
The result is 3
This method is less common but useful in certain calculations.
Common MIN Function Mistakes
Here are some mistakes beginners often make when using MIN.
Including Errors in the Range
If the range contains errors such as:
#DIV/0!
#VALUE!
The MIN function will return an error.
Fix this by:
- Cleaning your data
- Or using functions like IFERROR (covered in a future article)
Using MIN on Text Instead of Numbers
MIN only works with numeric values. If your numbers are stored as text, Excel will ignore them.
Fix this by:
- Converting text to numbers
- Using VALUE() if needed (covered in a future article)
Selecting the Wrong Range
Always double-check your selected range to ensure all intended values are included.
Real-World Uses for the MIN Function
The MIN function is widely used across many industries.
Here are common real-world examples:
- Finding the lowest monthly expense
- Identifying the fastest race time
- Determining the lowest sales value
- Finding the minimum temperature recorded
- Identifying the lowest test score
MIN is often paired with:
- MAX (highest value)
- AVERAGE (typical value)
- COUNT (number of values)
MIN vs MAX — Understanding the Difference
MIN and MAX are closely related functions.
- MIN returns the smallest value
- MAX returns the largest value
Example:
15, 42, 9, 27
Results:
=MIN(A1:A4) → 9
=MAX(A1:A4) → 42
These functions are frequently used together in reports and dashboards.
When Should You Use the MIN Function?
Use the MIN function anytime you need to quickly identify the lowest number in a dataset.
It works especially well when:
- Working with long lists
- Comparing values
- Monitoring minimum thresholds
- Analyzing trends
Because of its simplicity and speed, MIN is one of the most commonly used Excel functions.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> MIN Function Data
