Returns the minimum value.

Syntax

= MIN(number1, [number2], …)

Arguments

  • number1: A number, a cell that has a number, or a range of cells having numbers from which you want to get the smallest number.
  • [number2]: A number, a cell that has a number, or a range of cells having numbers from which you want to get the smallest number.

Notes

  • You can refer to a single cell, a named range, a range of cells or an array.
  • If there are no numbers in specified arguments it will return 0.
  • If there is a text or error value in the argument, it will return #N/A.
  • If you directly enter a logical value or a text which represents a number into the function, that will be counted.
  • It will only consider numeric values. Empty cells, text, and logical values in a reference or an array will be ignored.
  • The maximum number of arguments you can refer to is 255

Related


Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel for Mac