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.