WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » MIN in Excel

MIN in Excel

By Tanuj KumarTanuj Kumar | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

MIN in Excel

MIN function is categorized under statistical functions in Excel. The MIN Excel function is used to find out the minimum value from a given set of data/ array.  It returns the minimum value from a given set of numeric values.

  • It will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.
  • It can be used to calculate the minimum salary of the employee, the minimum time/score, lowest expense or revenue amount, etc.

MIN Formula in Excel

Below is the MIN Formula in Excel.

MIN Formula in Excel

MIN formula has at least one compulsory parameter, i.e., number1 and rest subsequent numbers are optional.

Compulsory Parameter:

  • number1: it is the required number.

Optional Parameter:

  • [number2]:  Rest subsequent numbers are optional.

How to Use MIN Function in Excel?

MINIMUM function in excel is very simple and easy to use. Let us understand the working of the MIN function in some examples. MIN can be used as a worksheet function and as a VBA function.

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

Example #1

In this example, we have a student database with their score details. Now we need to find out the minimum score from these students.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

MIN Example 1

Here apply the function =MIN(C3:C18)

MIN Example 1-1

and it will return you the minimum score from the given list of scores, as shown in the below table.

MIN Example 1-2

Example #2

In this example, we have student details with their score, but here some students did not have any score.

MIN Example 2

Now apply the function here =MIN(G3:G18)

MIN Example 2-1

MIN Function ignores the empty cells and then calculates the minimum score from the given data, as shown in the below table.

MIN Example 2-2

Example #3

Suppose we have a student details with their score but for some of the student’s  score values are Boolean,

MIN Example 3

then apply the function here =MIN(J3:J18),

MIN Example 3-1

MIN function in excel ignores these Boolean values cells and then calculates the minimum score from the given data, as shown in the below table.

MIN Example 3-2

Example #4

Suppose we have a list of names, and we have to calculate the name with minimum length.

Example 4

Here we have to apply the LEN function to calculate the length of the name, then apply the MIN function to find out the name with minimum length.

Example 4-1

It will give you the result, shown below.

Example 4-2

Example #5

MIN function can be used to find the MIN date from the given set of dates and minimum time from the given time and can be used to find the minimum currency from the given data, as shown in the below table.

Example 5

MIN function can be used as a VBA function.

Sub MINcal()

Dim Ans As Integer //declare the Ans as integer

Ans = Applicaltion.WorksheetFunction.MIN(Range(“A1:B5”))  // Apply Excel MIN function on range A1 to B5

MsgBox Ans //Display the MIN value in the Message box.

End Sub

Things to Remember

  • It throws #VALUE! Error if any of the supplied values are non-numeric.
  • It will count numbers but ignore empty cells, text,  the logical values TRUE and FALSE, and text values.
  • If this function does not have any numbers in the arguments, then it will return the 0 as output.

Recommended Articles

This has been a guide to MIN Function in Excel. Here we discuss the MIN Formula and how to use the MIN function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • VBA Boolean
  • Percentile Formula in Excel
  • VBA MsgBox Function in Excel
  • Delete Blank Rows in Excel
  • Add a Secondary Axis in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download MIN Function Excel Template

Coursera IPO Financial Model & Valuation Free Download