How to use the MIN function
The MIN function allows you to retrieve the smallest number in a cell range.
The formula in cell D3 extracts the smallest number from cell range B3:B10, see picture above.
Excel Function Syntax
MIN(number1, [number2], ...)
Arguments
number1 - You need at least one argument. Required.
[number2] - Up to 254 arguments are possible. Optional.
Arguments can be constants, named ranges, cell references and arrays.
The MIN function ignores text and boolean values, however not errors.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Articles with the 'MIN' Function
The following 4 articles have formulas that contain the MIN function.
Table of Contents Find closest value Find closest values Find closest values and return adjacent values Find closest value with […]
How to quickly find the maximum or minimum value [Formula]
Question: I have three columns and how do I identify the largest and smallest number? Where is the value? I […]
Smallest greater than condition
Question: Here is the problem: i have a data table with 2 columns: A B 2.93 12.8 2.94 12.2 3 […]
Functions in 'Statistical'
The MIN function function is one of many functions in the 'Statistical' category.
How to use the AVEDEV function
The AVEDEV function calculates the average of the absolute deviations of data points from their mean. The absolute deviation from the […]
How to use the AVERAGE function
Calculates the average of numbers in a cell range. In other words, the sum of a group of numbers and […]
How to use the AVERAGEA function
The AVERAGEA function returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to […]
How to use the AVERAGEIF function
The AVERAGEIF function returns the average of cell values that are valid for a given condition. Formula in cell D3: […]
How to use the AVERAGEIFS function
The AVERAGEIFS function returns the average of cell values that evaluates to TRUE for multiple criteria. Formula in cell F6: =AVERAGEIFS(D3:D8,B3:B8,F3,C3:C8,G3) […]
How to use the BETA.DIST function
The BETA.DIST function calculates the beta distribution. It represents outcomes in the form of probabilities. This function was introduced in Excel […]
How to use the BETA.INV function
The BETA.INV function calculates the inverse of the cumulative beta distribution. This function has replaced the BETA.INV function and was […]
How to use the BINOM.DIST function
The BINOM.DIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]
How to use the BINOM.INV function
The BINOM.INV function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]
How to use the CHISQ.DIST function
The CHISQ.DIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. It […]
How to use the CHISQ.DIST.RT function
The CHISQ.DIST.RT function was introduced in Excel 2010 and calculates the right-tailed probability of the chi-squared distribution. It has replaced the […]
How to use the CHISQ.INV function
The CHISQ.INV function was introduced in Excel 2010 and calculates the inverse of the left-tailed probability of the chi-squared distribution. […]
How to use the CHISQ.INV.RT function
The CHISQ.INV.RT function was introduced in Excel 2010 and calculates the inverse of the right-tailed probability of the chi-squared distribution. […]
How to use the CHISQ.TEST function
The CHISQ.TEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]
How to use the CONFIDENCE.NORM function
The CONFIDENCE.NORM function calculates the confidence interval for a population mean. Formula in cell C7: =CONFIDENCE.NORM(C3,C4,C5) Excel Function Syntax CONFIDENCE.NORM(alpha,standard_dev,size) […]
How to use the CONFIDENCE.T function
The CONFIDENCE.T function calculates the confidence range for a population mean using a Student's t distribution. Formula in cell C7: […]
How to use the CORREL function
The CORREL function calculates the correlation between two groups of numbers. Formula in cell B12: =CORREL(C3:C9, D3:D9) The value in cell […]
The COUNT function counts all numerical values in an argument, it allows you to have up to 255 arguments. Blank […]
How to use the COUNTA function
The COUNTA function counts the non-empty or blank cells in a cell reference. The picture above demonstrates the COUNTA function […]
How to use the COUNTBLANK function
The COUNTBLANK function counts empty or blank cells in a range. The picture above demonstrates the COUNTBLANK function entered in […]
How to use the COUNTIF function
Counts the number of cells that meet a specific condition.
How to use the COUNTIFS function
Checks multiple conditions against the same number of cell ranges and counts how many times all criteria are met.
How to use the COVARIANCE.P function
The COVARIANCE.P function calculates the covariance meaning the average of the products of deviations for each pair in two different […]
How to use the COVARIANCE.S function
The COVARIANCE.S function calculates the sample covariance meaning the average of the products of deviations for each pair in two […]
How to use the EXPON.DIST function
The EXPON.DIST function calculates the exponential distribution representing an outcome in the form of probability. This function was introduced in Excel […]
How to use the F.DIST function
The F.DIST function calculates the F probability for two tests. This function was introduced in Excel 2010 and has replaced […]
How to use the F.DIST.RT function
The F.DIST.RT function calculates the right-tailed F probability for two tests. This function was introduced in Excel 2010 and has replaced […]
How to use the F.TEST function
The F.TEST function calculates the two-tailed probability from an F-test, the value shows if the variances from two data sets […]
How to use the FORECAST.LINEAR function
The FORECAST.LINEAR function calculates a value based on existing x and y values using linear regression. Use this function to […]
How to use the FREQUENCY function
Returns how many times values exist in a given range. Note, this function returns an array of values.
The GAMMA function calculates the GAMMA value. It is an extension of the factorial function, the argument is shifted down […]
How to use the GAMMA.DIST function
The GAMMA.DIST function calculates the gamma often used in queuing analysis (probability statistics) that may have a skewed distribution. This […]
How to use the GEOMEAN function
The GEOMEAN function calculates the geometric mean. It represents the typical value of a set of numerical values based on the […]
How to use the GROWTH function
The GROWTH function returns estimated exponential growth based on given data. It calculates the y-values for new x-values based on […]
How to use the INTERCEPT function
The INTERCEPT function returns a value representing the y-value where a line intersects the y-axis. The line is calculated using […]
The LARGE function calculates the k-th largest value from an array of numbers. Use the LARGE function, for example, to extract […]
How to use the LINEST function
The LINEST function returns an array of values representing the parameters of a straight line based on the "least squares" […]
How to use the LOGEST function
The LOGEST function returns an array of values representing the parameters of an exponential curve that fits your data, based […]
