MIN Function

Returns the lowest number or earliest date.
Sample Usage
MIN(Cost1:Cost5)
Syntax
MIN(
  • value1
  • [
    • value2
      • ​
    • ...
    ]
)
  • value1
    —
    The number or range from which you want the lowest value.
    • value2
      • ​
    • ...
    —[optional]
    Additional numbers or ranges.
Usage Notes
  • When referencing dates, you must use MIN in a Date column. See Column Types for more information on Date columns.
Related Functions
MAX
AVG
AVGW