Microsoft Excel MIN Function Help

MIN Function Examples

• Click to view MIN function examples

MIN Function Definition

Returns the smallest value from a worksheet range or set of values.

MIN Function Syntax

=MIN(number1,number2,...)

MIN Function Argument Definitions

number1, number2, ...:  These are 1 to 30 numbers for which you want to find the minimum value. They can be cell references like A1, range references like A1:A10 or cell names and range names. They can even be formulas and other functions.

MIN Function Tips

• The arguments for this function can either be numbers or names, arrays, or range references that contain numbers.
• You can type logical values and text representations of numbers directly into the argument list and they will be counted.
• If an argument is range reference or an array, only numbers the numbers are analyzed. Empty cells, logical values and text are ignored.
• Any arguments that produce error values or text that cannot be translated into numbers can cause errors.
• If you want to include logical values and text representations of numbers in a reference as part of the calculation, try using the MINA function.

MIN Function Examples

• Click to view MIN function examples