Introduction
The MIN function in Excel finds the smallest numeric value in a group of numbers. It is useful for identifying the lowest product price, minimum employee salary, lowest daily sales, earliest date, and minimum business performance.
In this tutorial, you will learn the MIN Function in Excel Tutorial through practical company examples, progressing from basic calculations to conditional analysis, filtered data, and Excel Tables. Each question introduces a different concept, helping you build practical Excel skills.
MIN Function Syntax
=MIN(number1, [number2], ...)- number1: The first number, cell reference, or range.
- number2: Additional numbers, cells, or ranges. This argument is optional.
Example:
=MIN(B2:B10)This formula returns the smallest numeric value in cells B2 through B10.
Question 1: Find the Lowest Daily Sales
Problem Statement:
A company wants to identify the day with the lowest sales during the working week.
Data:
| Day | Sales (₹) |
|---|---|
| Monday | 18,000 |
| Tuesday | 22,000 |
| Wednesday | 15,000 |
| Thursday | 25,000 |
| Friday | 20,000 |
Excel Formula:
=MIN(B2:B6)Expected Result: ₹15,000
Student Task:
Add Saturday’s sales of ₹12,000 in cell B7. Update the formula to include Saturday.
Expected Result: ₹12,000
Business Challenge: Can you identify the day with the lowest sales using the MIN function and the sales table?
Question 2: Find the Smallest Value Among Selected Cells
Problem Statement:
A sales manager wants to compare only selected sales records instead of the entire column.
Data:
| Record | Sales (₹) |
|---|---|
| Record 1 | 45,000 |
| Record 2 | 32,000 |
| Record 3 | 48,000 |
| Record 4 | 51,000 |
| Record 5 | 27,000 |
| Record 6 | 40,000 |
Excel Formula:
=MIN(B2,B5,B7)Expected Result: ₹27,000
The formula checks only the three selected cells: B2, B5, and B7.
Student Task:
Find the minimum value among Record 2, Record 4, and Record 6.
Expected Formula:
=MIN(B3,B5,B7)Expected Result: ₹32,000
Question 3: Find the Lowest Employee Salary
Problem Statement:
The HR department wants to identify the lowest monthly salary in the company.
Data:
| Employee | Monthly Salary (₹) |
|---|---|
| Amit | 45,000 |
| Priya | 52,000 |
| Rahul | 38,000 |
| Neha | 60,000 |
| Karan | 48,000 |
Excel Formula:
=MIN(B2:B6)Expected Result: ₹38,000
Student Task:
Add a new employee named Riya with a salary of ₹35,000 in row 7. Update the formula.
Expected Formula:
=MIN(B2:B7)Expected Result: ₹35,000
Business Use: HR teams can use MIN to identify the lowest salary in a dataset. Before making decisions, they should also consider job roles, experience, and salary policies.
Question 4: Understand How MIN Handles Blank Cells, Text, and Zero
Problem Statement:
An inventory team records product prices. Some products have missing prices, and one product has a confirmed price of zero.
Data:
| Product | Price (₹) |
|---|---|
| Keyboard | 1,200 |
| Mouse | (Blank) |
| Promotional Item | 0 |
| Headphones | 950 |
| Monitor | Out of stock |
Excel Formula:
=MIN(B2:B6)Expected Result: ₹0
MIN ignores blank cells and text in a referenced range, but it includes numeric zero.
Student Task:
Replace the zero in the Promotional Item row with a blank cell. Calculate the minimum price again.
Expected Result: ₹950
Remember: A zero is a number, not an empty cell. This difference can affect your results.
Question 5: Find the Lowest Profit, Including Losses
Problem Statement:
A company wants to identify its worst daily financial result. Some days have losses, represented by negative numbers.
Data:
| Day | Profit/Loss (₹) |
|---|---|
| Monday | 5,000 |
| Tuesday | -1,200 |
| Wednesday | 3,000 |
| Thursday | -500 |
| Friday | 2,500 |
Excel Formula:
=MIN(B2:B6)Expected Result: -₹1,200
A negative value represents a loss. Since -1,200 is smaller than the other values, MIN returns it.
Student Task:
Change Thursday’s result from -₹500 to -₹1,800. Find the new minimum.
Expected Result: -₹1,800
Business Challenge: Explain why -₹1,800 is smaller than ₹2,500, even though its absolute value is lower than some positive values.
Question 6: Find the Minimum Across Multiple Ranges
Problem Statement:
A company stores prices for two product categories in separate columns. The manager wants to find the lowest price across both categories.
Data:
| Category A Price (₹) | Category B Price (₹) | |
|---|---|---|
| 120 | 110 | |
| 95 | 85 | |
| 140 | 105 |
Assume Category A prices are in B2:B4 and Category B prices are in D2:D4.
Excel Formula:
=MIN(B2:B4,D2:D4)Expected Result: ₹85
Student Task:
Add a new price of ₹75 in cell D5. Update the formula to include the new value.
Expected Formula:
=MIN(B2:B4,D2:D5)Expected Result: ₹75
Question 7: Find the Earliest Date in a Dataset
Problem Statement:
An HR department stores employee joining dates. It wants to identify the earliest joining date.
Data:
| Employee | Joining Date |
|---|---|
| Amit | 15-Jan-2025 |
| Priya | 03-Jan-2025 |
| Rahul | 22-Jan-2025 |
| Neha | 10-Jan-2025 |
Assume the joining dates are in cells B2 and are stored as valid Excel dates.
Excel Formula:
=MIN(B2:B5)Expected Result: 03-Jan-2025
If Excel displays a number instead of a date, format the result cell as a Date.
Student Task:
Add Karan with a joining date of 01-Jan-2025. Update the formula.
Expected Result: 01-Jan-2025
Business Use: MIN can identify the earliest joining date, first transaction date, or earliest recorded order date when the values are stored as valid Excel dates.
Question 8: Find the Minimum Sales for a Specific Region Using MINIFS
Problem Statement:
A company wants to find the lowest sales value for each region without manually filtering the dataset.
Data:
| Region | Sales (₹) |
|---|---|
| North | 100 |
| East | 200 |
| North | 300 |
| West | 400 |
| North | 250 |
| East | 180 |
| West | 150 |
Assume regions are in A2:A8 and sales are in B2:B8.
Excel Formula:
=MINIFS(B2:B8,A2:A8,"North")Expected Result: ₹100
The MINIFS function finds the smallest sales value only among rows where the region is North.
Student Task:
Find the minimum sales value for the East region.
Expected Formula:
=MINIFS(B2:B8,A2:A8,"East")Expected Result: ₹180
Important: MINIFS is available in Excel versions that support it, including Excel 2019 and Microsoft 365. If your Excel version does not support MINIFS, a different formula may be needed.
Question 9: Find the Lowest Price in an Excel Table
Problem Statement:
An inventory team regularly adds new products to an Excel Table. The manager wants to identify the lowest product price without manually updating the range every time.
Data:
| Product | Unit Price (₹) |
|---|---|
| Keyboard | 1,200 |
| Mouse | 800 |
| Monitor | 2,500 |
Convert the data into an Excel Table and name it Inventory. Make sure the price column is named Unit Price.
Excel Formula:
=MIN(Inventory[Unit Price])Expected Result: ₹800
Student Task:
Add a new product named Printer with a unit price of ₹650.
Expected Result: ₹650
Why use an Excel Table? Structured references can automatically include new table rows, making formulas easier to maintain as your dataset grows.
Student Challenge: Build a Minimum Price and Sales Report
A company wants to review product prices and monthly sales using Excel.
Data:
| Product | Unit Price (₹) | January Sales (₹) | February Sales (₹) |
|---|---|---|---|
| Keyboard | 800 | 12,000 | 15,000 |
| Mouse | 500 | 8,000 | 9,000 |
| Monitor | 8,000 | 25,000 | 22,000 |
| Printer | 5,000 | 18,000 | 20,000 |
| Webcam | 1,200 | 10,000 | 11,000 |
Your Tasks
- Find the lowest unit price.
- Find the lowest January sales value.
- Find the lowest February sales value.
- Identify the lowest sales value across both months.
- Add a new product named Headset with a unit price of ₹400, January sales of ₹7,000, and February sales of ₹6,000. Update the minimum values.
Answer Key
1. Lowest unit price
=MIN(B2:B6)Expected result: ₹500
2. Lowest January sales
=MIN(C2:C6)Expected result: ₹8,000
3. Lowest February sales
=MIN(D2:D6)Expected result: ₹9,000
4. Lowest sales across both months
=MIN(C2:D6)Expected result: ₹8,000
5. Updated minimum values after adding Headset
If the new product is entered in row 7:
- Lowest unit price: ₹400
- Lowest January sales: ₹7,000
- Lowest February sales: ₹6,000
- Lowest sales across both months: ₹6,000
Key Takeaways
- The MIN function returns the smallest numeric value in a range or set of values.
- Use
=MIN(B2:B10)to find the lowest number in a continuous range. - Use commas to compare selected cells or multiple ranges.
- Blank cells and text in referenced ranges are ignored, but numeric zero and negative numbers are included.
- MIN in excel can find the earliest date when the cells contain valid Excel dates.
- Use MINIFS to find the minimum value that meets a condition.
- Use
SUBTOTAL(5,range)to calculate the minimum of visible rows after filtering. - Structured references make MIN formulas easier to maintain in Excel Tables.
- Combine MIN with IF to identify records matching the minimum value.
Frequently Asked Questions (FAQs)
1. What is the MIN function in Excel?
The MIN function returns the smallest numeric value from a group of numbers, cells, or ranges.
2. What is the syntax of the MIN function?
The syntax is =MIN(number1, [number2], ...). You can provide individual numbers, cell references, or ranges.
3. Does MIN ignore blank cells?
Yes. Blank cells in a referenced range are ignored.
4. Does MIN include zero?
Yes. Zero is a numeric value, so it can become the minimum result.
5. Does MIN ignore text?
MIN ignores text in referenced ranges. However, text entered directly as a formula argument may cause an error.
6. Can MIN find the earliest date?
Yes. If the cells contain valid Excel dates, MIN returns the earliest date.
7. What is the difference between MIN and MINIFS?
MIN returns the smallest numeric value across the supplied values. MINIFS returns the smallest value that meets one or more specified conditions.
8. How can I find the minimum value after applying a filter?
Use =SUBTOTAL(5,B2:B10). It calculates the minimum among visible rows and excludes rows hidden by the filter.
9. Can MIN work with negative numbers?
Yes. MIN compares negative and positive numbers and returns the numerically smallest value. For example, =MIN(-5,3,10) returns -5.
10. What happens if all cells in a range are blank or contain text?
MIN returns 0 when there are no numeric values to evaluate in the referenced range.