Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

MIN

Returns the minimum value in a dataset.

Sample Usage

MIN(20,30)
MIN(A2:A6)
MIN(A1:B2,5)

Syntax

MIN(value1, [value2, ...])

  • value1 - The first value or range to consider while calculating the minimum value.
  • value2, .. - [OPTIONAL] Additional numbers or ranges to consider.

Examples

 

MIN(20,30) returns the value 20.
MIN(A2:A6) returns the smallest number in the range A2 through A6.
MIN(A1:B2,5) returns the smallest number among the numbers contained in cells A1 through B2 and the number 5.

 

Notes

  • Arguments must be a cell, a number, or a range containing numbers.
  • Cells without numbers or ranges are ignored.
  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.