EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Statistical Functions in Excel Excel MIN Function
Secondary Sidebar
Excel Functions
  • Statistical Functions in Excel
    • COUNTIF Formula in Excel
    • COUNTIF Multiple Conditions
    • COUNTIFS with Multiple Criteria
    • Statistics in Excel
    • Confidence Interval in Excel
    • Interpolate in Excel
    • Linear Programming in Excel
    • COUNTIFS in Excel
    • Excel Variance
    • Normal Distribution Formula in Excel
    • Count Cells with Text in Excel
    • Excel Formula For Rank
    • Linear Regression in Excel
    • COUNTA Function in Excel
    • MAX Formula in Excel
    • Excel NORMSINV
    • Count Names in Excel
    • FORECAST Formula in Excel
    • NPER in Excel
    • Excel Median Formula
    • Lognormal Distribution in Excel
    • Excel Chi Square Test
    • Count Formula in Excel
    • COUNTIF Examples in Excel
    • Excel P-Value
    • COUNTIF Not Blank in Excel
    • Excel Standard Deviation Formula
    • Excel GROWTH Formula
    • Excel Percentile Formula
    • Excel Frequency Formula
    • Excel Average Formula
    • Excel Correlation Matrix
    • Excel Z Score
    • Excel MAX IF Function
    • Z TEST in Excel
    • Excel Trendline
    • Excel F-Test
    • Excel STDEV Function
    • Excel Frequency Distribution
    • DCOUNT Function in Excel
    • Excel MIN Function
    • Excel Forecast Function
    • FREQUENCY Excel Function
    • COUNTIF with Multiple Criteria
    • Standard Deviation in Excel
    • MAX Excel Function
    • Excel QUARTILE Function
    • Excel T.Test Function
    • Excel PERCENTILE Function
    • MODE Excel Function
    • SLOPE Excel Function
    • Excel Median Function
    • Excel TREND Function
    • Excel Count Function
    • Excel LARGE Function
    • SMALL Excel Function
    • COUNTIF Excel Function
    • Excel AVERAGE Function
    • Excel CORREL Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training Certification
  • Online Excel for Marketing Course

Excel MIN Function

By Karthikeyan SubburamanKarthikeyan Subburaman

MIN in excel

MIN Function in Excel (Table of Contents)

  • MIN in Excel
  • MIN Formula in Excel
  • How to Use MIN Function in Excel?

MIN in Excel

Min function simply returns the minimum or lowest value from the selected range of numbers; whether a number is positive or negative, it will return the lowest number in both manners. For this, we just require a minimum of 2 numbers; at least among those using the Min function, we can find which is the lowest number. It does not consider text or any other character apart from the number, but it skips these things if it ever comes into the selected range.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

MIN Formula in Excel:

Below is the MIN Formula:

MIN Formula in Excel

Arguments:

number1:- This number1  refers to a numeric value or range which contains a numeric value.

number2-[optional]:- This number2  refers to a numeric value or range which contains a numeric value.

Steps to Open MIN Function in Excel:

We can find the MIN function in Excel under the category statistical function.

  • Choose formulas. Click insert function. We will get a dialogue box. In the dialogue box, choose the category and select the MIN function.

MIN Step 1

  • Another way of the shortcut is in the advanced version; we can find more options in the formula bar. Choose more functions and select the category statistical and choose the MIN function.

MIN Step 2

Now let’s see the example of how the Min function works with the given data.

How to Use MIN Function in Excel?

MIN Function is very simple to use. Let us now see how to use the MIN function in Excel with the help of some examples.

You can download this MIN Function Excel Template here – MIN Function Excel Template

Example #1

In the following example, we are going to see the MIN function using numerical values, text, null values, and negative values.

MIN function in excel always returns the smallest value depends on the given data.

Negative Value:

MIN Function in excel always considers the numeric values; even if we have a range of negative values, it will consider only numeric values.

If we have data with negative values, this MIN function will consider the lowest negative values of the given data and return the lowest negative value. Let’s see the below example, which shows sales data with negatives values.

MIN Example 1-1

In the above example, now we are going to find out the minimum sales values and follow the below steps.

  • Insert the MIN function

MIN Example 1-2

  • Select the cell from where the data has been placed to assume that selecting C2:C9

MIN Example 1-3

Result:

In the above example, we have seen the MIN function return the lowest negative value as-150. We can understand that the MIN function will consider numeric values and the lowest negative values.

 MIN Example 1-4

Text Values :

Let us see another example using text where the MIN function is used exactly.

We will consider the same sales data with little modification changed in sales data shown below.

MIN Example 1-5

In the above sales data, we noticed that we had mentioned some grade names to the particular product name where Walker is named Grade A and Car Seat is named Grade B, the most top-selling online selling product.

Now we are going to use the MIN function to calculate the smallest value as we have already mentioned that the MIN function only consider the numeric values and omits the text values

Let’s apply the MIN function and check the result.

  • First, insert the function MIN

MIN Example 1-6

  • Select the cells from C2:C9
  • =MIN(C2:C9)

MIN Example 1-7

The above example clearly shows that the MIN function considered only numeric values, omitted the text, and returned the smallest value of the given values.

 MIN Example 1-8

MIN function using NULL Values:

Assume that we have sales data with null values where sales have not happened for the specific month; in this case, if we apply the MIN function, it will consider the same numeric values and omits the null values.

Let’s see a working example to check the result; we have modified the same sales data with some small modifications where we have mentioned some of the product sales values as null values, i.e. blank values.

MIN Example 1-9

  • First, insert the MIN function

MIN Example 1-10

  • Select the cell from C2:C9
  • =MIN(C2:C9)

MIN Example 1-11

Result:

In the below example, the MIN function returned only the MIN value and omitted the null values shown below.

MIN Example 1-12

In this example, we have some range of numbers in the A and B column

MIN Example 1-13

Follow the below steps to find out the minimum value.

  1. First, enter the function in cell A8

MIN Example 1-14

  1. =MIN(A2:A7).

MIN Example 1-15

  1. Press Enter.

Now the MIN function will find the minimum value within the range of data, and the result has been shown below.

MIN Example 1-16

Similarly, we find min value for column B

MIN Example 1-17

So we have found out the minimum value as 12 within the given range of data, and the same as in the B column, the min value is 11.

Example #2

In the below example, we have some set of sales data with category wise sales value. Assume that we need to find out the specific category of minimum sales value. Here MIN function will be useful to find out the exact match.

MIN Example 2-1

In this example, we are going to find the specific category named stroller MIN value; in order to find out the minimum value, please follow the below step

  • Insert the MIN function

MIN Example 2-2

  • Select the category type stroller
  • =MIN(G2,G3,G8,G9)

MIN Example 2-3

  • Press Enter
  • We will get the result as 125 as the MIN value for the category stroller

MIN Example 2-4

Example #3

Let’s see another example where we need to find the lowest mark of the students by gender-wise.

MIN Example 3-1

In order to find out the Lowest mark of the student’s gender-wise, please follow the below steps.

  • Insert the MIN Function

MIN Example 3-2

  • Select the Gender column male and choose the MIN number.
  • =MIN(L2,L3,L4,L5,L6)

MIN Example 3-3

Result:

Now we got the lowest mark for the male category as 35

MIN Example 3-4

Now we need to find out the Lowest mark for the female category

In order to find out the Lowest mark of the student’s gender-wise, please follow the below steps

  • Insert the MIN Function

MIN Example 3-5

  • Select the Gender column female and choose the MIN number.
  • =MIN(L7,L8,L9)

MIN Example 3-6

Result:

Finally, we got the lowest mark under the female category, as shown below

MIN Example 3-7

Suppose if we have GRADE mentioned in the student’s mark list, how this MIN function works. Let’s see with the example

MIN Example 3-8

  • Insert the MIN function

MIN Example 3-9

  • Select the female gender category
  • =MIN(L7,L8,L9)

MIN Example 3-10

We have seen that in the MARKS Column, Grade A is mentioned for the particular student; if we apply the min function, excel will take only integer values and return the minimum value as shown in the below screenshot.

MIN Example 3-11

Common errors occur while using MIN in Excel:

  • #Value: we have seen this error mostly in all the cases min function return this error if any non-numeric values have been used.
  • MIN function will not consider logical, null, and text values.

Recommended Articles

This has been a guide to the Excel MIN function. Here we discuss the MIN Formula and how to use the MIN function along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. MINVERSE in Excel
  2. MAX Excel Function
  3. Excel MAX IF Function
  4. Excel SUM MAX MIN AVERAGE
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for Marketing Training (8 Courses, 13+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download MIN Function Excel Template

EDUCBA

Download MIN Function Excel Template

EDUCBA

डाउनलोड MIN Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more