MIN
Use MIN when you need the minimum value from a series of number, date, time, or text values.
The MIN function returns the minimum value from a series.
- Syntax:
- MIN (series-item-expression)
- Meaning:
- MIN (series_of_which_to_find_min)
- Returns:
- A single number
The result is the minimum value of the input series: number, text, or date/time.
Examples
- MIN (UnitPrice:Input)
If the values for UnitPrice are {20,10,100}, MIN returns 10.
- MIN (StartTime:.:Schedule)
Returns the minimum (earliest) StartTime in Schedule.
Related functions
- MAX