MIN Function in Excel – Get the Minimum value in Excel

MIN function in Excel returns the smallest value or minimum value from a supplied set of numeric values.

 

Syntax of MIN Function in Excel:

MIN( number1, [number2], … )

Where the number arguments are one or more numeric values from which you want to find the minimum value in Excel

 

Example of MIN Function in Excel:

Formula

MIN function in Excel 1

  • Text and Logical values are ignored by Excel MIN Function
  • In First Example MIN Function takes up the cell reference and finds the minimum value
  • In Second Example MIN Function takes up the values directly and finds the minimum value
Result

MIN function in Excel 2

previous-small MIN Function in Excel                                                                                                                next_small MIN Function in Excel