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