Excel MIN Function

This post will guide you how to use Excel MIN function with syntax and examples in Microsoft excel.

Description

The Excel MIN function returns the smallest numeric value from the numbers that you provided. Or returns the smallest value in the array.

The MIN function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.

The MIN function is available in Excel 2016, excel 2013, excel 2010, excel 2007, excel 2003, excel XP, excel 2000, excel 2011 for Mac.

Syntax

The syntax of the MIN function is as below:

= MIN(num1,[num2,…numn])

Where the MIN function arguments are:

  • num1 -This is a required argument. A number, or a reference to a number or a range that contains numeric values
  • Num2,…Numn – This is an optional argument.  A number, or a reference to a number or a range that contains numeric values

Note:

  • The MIN function will not compare empty cells
  • The MIN function can accept up to 255 arguments with numeric value.
  • The MIN function will ignore Boolean values (TRUE and FALSE)
  • The MIN function will ignore numbers that the format is text.
  • The returned value of The MIN function is a numeric value.

Excel MIN Function Examples

The below examples will show you how to use Excel MIN Function to get the smallest value form the numbers.

#1 To get the smallest value from the column A, just using the following excel formula:

=MIN(A:A)
excel min function 1

More MIN Function Examples


  • Split Text and Numbers
    If you want to split text and numbers from one cell into two different cells, you can use a formula based on the FIND function, the LEFT function or the RIGHT function and the MIN function. .…
  • Limit Formula Result to Maximum or Minimum Value
    You can use the MIN function or Max function to create a formula to limit a number within a minimum or maximum value. .….
  • Converting Week Number to Date
    You need to create a formula based on the MAX function, the DATE function and the WEEKDAY function to convert week number to a date in Excel.…
  • Return Larger or Smaller of Two Values
    To get the larger value from two values, you need to create a formula based on the MAX function, To get the smaller of two values, you can use the MIN function.…
  • Find Closest Value or Nearest Value in a Range
    You need to use an excel array formula based on the INDEX function, the MATCH function, the MIN function and the ABS function to find Closest Value or Nearest Value in a Range in Excel…
Related Posts

How to Look Up the Lowest Value in A List by VLOOKUP/INDEX/MATCH Functions in Excel
Look Up the Lowest Value in A List by VLOOKUPINDEXMATCH 6

VLOOKUP function is very useful in our daily work and we can use it to look up match value in a range, then get proper returned value (the returned value may be just adjacent to the match value). Sometimes we ...

How to Find the Earliest and Latest Date in Excel
Find the Earliest and Latest Date 10

We have a range of dates and we want to look up the earliest and the latest date based on certain criteria like the earliest date for a showing movie, we can use MIN and MAX functions with IF function ...

How to Find the Smallest Value and Smallest Positive Value in Excel
Find the Smallest Positive Value 9

Sometimes we want to find out the smallest positive value among a set of values. We should ignore the negative value and zero value when getting the smallest positive value. So we design different cases in this article to demonstrate ...

How to Calculate the Average Excluding the Smallest & Highest Numbers in Excel
Calculate the Average Excluding the Smallest & Highest 10

Calculating the average for a batch of data is frequently used in our daily life. But for some cases like statistic the average score in a competition, or price analysis, we often calculate the average excluding the smallest and highest ...

How to Get the Maximum or Minimum Absolute Value in Excel
Get the Maximum or Minimum Absolute Value 10

It is easy to find the maximum or minimum value in a batch of data in excel, but if this batch of numbers contains both positive and negative numbers, the maximum or minimum absolute value cannot be found out by ...

How to Find Max And Min Value with Single or Multiple Criteria in Excel
find max value based single criteria5

This post will guide you how to find the maximum value in a range of cells based on single or multiple criteria in Excel. How do I calculate the Minimum value based on criteria with MIN Function in Excel. Find ...

How to Check If value Is between Two Numbers in Excel
check value is between two numbers2

This post will guide you how to check if a cell value is between two numbers in Excel. How do I build an IF statement that test if a cell value is between two given values in formula in Excel. ...

How to Get Cell Address of Max or Min Value in a Range in Excel
get cell address of max value2

This post will guide you how to return the cell address of a maximum cell value from a given range of cells with a formula in Excel. How do I Find the minimum value from a given range and return ...

How to Highlight The Highest and Lowest Value in Each Row or Column in Excel
highlight highest value in row11

This post will guide you how to highlight the highest value in each row or column in Excel. How do I highlight the lowest value in each row and column with conditional formatting function. Highlight Highest Value in Each Row ...

How to Display Negative Time Value in Excel
display negative time5

This post will guide you how to display negative time value in Excel. How do I change the way negative times are displayed in Excel. How to show negative dates or times with a formula in Excel. Display Negative Time ...

Sidebar