Written By Sophanith Dith
Last Updated June 02, 2026
Applies to Microsoft Excel 365 (Windows only)
The MIN and MAX functions help you quickly find the lowest and highest numbers in a range of cells. If you are learning how to use min and max function in excel, these two functions are among the easiest and most useful functions to start with.
You can use them in sales reports, budgets, score sheets, inventory lists, employee records, and many other worksheets where you need to identify the smallest or largest value. Instead of scanning numbers manually, Excel can return the answer instantly.
Before looking at examples, it helps to understand exactly what each function is designed to do.
What the MIN and MAX Functions Do
The MIN and MAX functions answer two simple questions: “What is the lowest number?” and “What is the highest number?” They are useful whenever your worksheet contains numbers that need quick comparison.
For example, in a workbook named Sales_Report.xlsx, you may have daily sales amounts in column B. The MIN function can show the lowest sales day, while the MAX function can show the highest sales day. Both functions return a number as the result.
- MIN returns the smallest numeric value in a selected range.
- MAX returns the largest numeric value in a selected range.
They return the number itself, not the related name, date, product, or label beside that number.
If your data contains blank cells, Excel ignores them. If your range contains text labels, Excel usually ignores those too when they are inside a cell range.
Once you know what the formulas return, the next step is learning their syntax.
MIN and MAX Formula Syntax
The syntax tells Excel what information the function needs. Both MIN and MAX use the same basic structure, so they are easy to learn together.
Here is the official syntax:
=MIN(number1, [number2], ...)
=MAX(number1, [number2], ...)
The arguments tell Excel which numbers or cell ranges to check.
| Argument | Required? | What It Means |
|---|---|---|
| number1 | Yes | The first number, cell, or range you want Excel to check |
| [number2] | Optional | Additional numbers, cells, or ranges to include |
| … | Optional | More values or ranges if needed |
For most beginner worksheets, you will usually use one range, such as:
=MIN(B2:B10)
or:
=MAX(B2:B10)
To use the MAX function in Excel, choose the range that contains the numbers you want to compare. To use the MIN function in Excel, use the same range structure, but Excel returns the smallest number instead of the largest one.
Now let’s apply both formulas to a simple worksheet example.
Basic Example of MIN and MAX in Excel
A basic example makes the formula easier to understand because you can see the data, formula, and result together. Suppose you are tracking test scores in a worksheet.
| Student | Score |
|---|---|
| Anna | 84 |
| Ben | 76 |
| Chloe | 91 |
| Daniel | 68 |
| Emma | 88 |
| Faisal | 95 |
| Grace | 79 |
To find the lowest score, enter:
=MIN(B2:B8)
Excel returns:
68
To find the highest score, enter:
=MAX(B2:B8)
Excel returns:
95
The MIN formula returns 68 because it is the smallest number in the range B2:B8. The MAX formula returns 95 because it is the largest number in that same range.
This example shows the basic pattern you will use in most worksheets. For Microsoft’s official explanation, you can also see their guide on calculating the smallest or largest number in a range in Excel.
After you understand the basic structure, you can use the same idea in many real worksheets.
Practical Real-World Examples
MIN and MAX are useful because they work with common worksheet data, not just practice numbers. The examples below show how the formulas can help with simple business, budget, and tracking tasks.
Example 1: Find the Lowest and Highest Monthly Expense
In Budget.xlsx, suppose your monthly expenses are listed in cells B2:B13. You want to know the smallest and largest monthly spending amount.
Use this formula to find the lowest expense:
=MIN(B2:B13)
Use this formula to find the highest expense:
=MAX(B2:B13)
This is helpful because it shows which month had the lowest spending and which month had the highest spending. If the numbers are formatted as currency, the result will be easier to read. For more help with number appearance, see how to format numbers in Excel.
Example 2: Find the Best and Worst Sales Day
In Sales_Report.xlsx, assume daily sales totals are in cells C2:C31. You can use MIN and MAX to summarize the range quickly.
To find the lowest daily sales total:
=MIN(C2:C31)
To find the highest daily sales total:
=MAX(C2:C31)
This helps you spot the weakest and strongest sales days without sorting the data. If you later want to organize the full report, you can learn more in how to sort data in Excel, but the formula itself gives the lowest or highest value immediately.
Example 3: Find the Lowest and Highest Inventory Quantity
In an inventory worksheet, product quantities may be listed in column D. The MIN function can help you find the lowest stock quantity, while MAX can show the highest stock quantity. If the quantities are in cells D2:D100, you can use these formulas:
=MIN(D2:D100)
=MAX(D2:D100)
This is useful when you want to quickly check whether any product has very low stock. MIN does not tell you the product name by itself; it only returns the lowest number. That keeps this guide focused on the formula result, not a larger lookup workflow.
Example 4: Use MIN and MAX with Separate Values
You do not always need to use a cell range. You can also type numbers directly inside the formula.
=MIN(45, 62, 38, 71)
This returns:
38
=MAX(45, 62, 38, 71)
This returns:
71
This method is less common in real worksheets, but it helps beginners see how the functions compare values.
These examples are simple, but the same pattern works in larger reports too. The main thing is selecting the correct range.
Common Mistakes When Using MIN and MAX
Most MIN and MAX errors come from selecting the wrong cells or expecting the formula to return more information than it actually does. Here are the mistakes beginners should watch for.
Mistake 1. Selecting the wrong range
If your data is in B2:B20 but your formula uses B2:B10, Excel only checks part of the list.
Incorrect:
=MAX(B2:B10)
Correct:
=MAX(B2:B20)
Always check that the range includes all the numbers you want to compare.
Mistake 2. Expecting MIN or MAX to return a label
MIN and MAX return a number only. If the highest sales value is next to a date or product name, MAX will not automatically return that date or product name.
For example:
=MAX(C2:C31)
This returns the highest number in C2:C31, not the matching date from column A.
Mistake 3. Including numbers stored as text
If numbers are stored as text, Excel may ignore them in a range. This can make the result look wrong.
A quick correction is to convert the text values into real numbers before using MIN or MAX. This issue often appears after importing data from another system.
Beginner Warning:
If a number is aligned differently from the others or came from imported data, it may be stored as text. Convert it to a real number before trusting the MIN or MAX result.
Mistake 4. Mixing separate ranges incorrectly
You can include more than one range, but each range must be separated by a comma.
Correct:
=MIN(B2:B10, D2:D10)
Incorrect:
=MIN(B2:B10 D2:D10)
The incorrect version is missing the comma between ranges.
Mistake 5. Thinking blank cells count as zero
Blank cells are ignored by MIN and MAX. If your range has blanks, Excel does not treat them as zero unless there is an actual 0 in a cell.
This matters in budget or inventory sheets where blank cells may mean “not entered yet,” not zero.
Once these mistakes are clear, it is also useful to know which related formulas may help in nearby situations.
Related Formulas
MIN and MAX are often used with other basic summary formulas. These related formulas are helpful, but they solve different problems.
| Formula | What It Does | How It Differs |
|---|---|---|
| SUM | Adds numbers together | Returns a total, not the lowest or highest number |
| AVERAGE | Finds the average value | Shows the middle tendency, not the smallest or largest value |
| MINIFS | Finds the lowest value based on criteria | Useful when you need conditions |
| MAXIFS | Finds the highest value based on criteria | Useful when you need conditions |
For example, SUM is used when you want a total, while MIN and MAX are used when you want the lowest or highest value. If you already learned how to use the SUM function in Excel, MIN and MAX are a natural next step because they help you summarize a range in a different way.
MINIFS and MAXIFS are useful when you need conditions, but they are more advanced than basic MIN and MAX. For this beginner guide, focus first on simple ranges.
Before you finish, try a few short practice tasks to make the formulas easier to remember.
Quick Practice
Use XcelTips_Practice.xlsx to practice MIN and MAX on a small dataset. These exercises are short and focus only on the formula.
- Enter ten sales amounts in cells
B2:B11. InB13, use=MIN(B2:B11)to find the lowest sale. - In
B14, use=MAX(B2:B11)to find the highest sale. - Change one number in the range and watch how the MIN or MAX result updates automatically.
These quick exercises help you see that the formulas update whenever the source numbers change.
Frequently Asked Questions (FAQs)
Here are common beginner questions about MIN and MAX in Excel.
What is the difference between MIN and MAX in Excel?
MIN returns the lowest number in a range, while MAX returns the highest number in a range. They use the same type of syntax but return opposite results.
How do I use MIN and MAX together in Excel?
You can use them in separate cells. For example, enter =MIN(B2:B10) to find the lowest value and =MAX(B2:B10) to find the highest value from the same range.
Can MIN and MAX ignore blank cells?
Yes. Blank cells are ignored. If a cell is empty, Excel does not count it as zero.
Why is my MIN or MAX result wrong?
The most common reasons are an incorrect range, numbers stored as text, hidden rows you forgot about, or cells that do not contain real numeric values.
Can I use the Excel MAX function in a full report?
Yes. The formula works the same way in a full report, but you need to make sure the selected range includes all the numbers you want Excel to check.
Now that you know the basics, you can use MIN and MAX whenever you need to summarize numeric data quickly.
Conclusion
Learning how to use min and max function in excel helps you find the lowest and highest values without checking numbers manually. MIN returns the smallest number, MAX returns the largest number, and both formulas work well with simple ranges in everyday worksheets.
Practice these formulas with small datasets first, then use them in budgets, sales reports, inventory lists, and score sheets. To continue building your formula skills, review how to use the SUM function in Excel, explore how to find average in Excel using the AVERAGE function, or follow the Excel Beginner Learning Path for a structured next step.