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.
-
—[optional]
- value2
- ...
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.