MIN function

MIN (First, Other...) MIN (First; Other...)

First

The first number or array of numbers.

Other

Additional numbers or arrays of numbers.

Returns

Number Number

The smallest number of the given numbers.

Returns the smallest number of the given numbers. MIN (4, 22, - 4, 32) MIN (4; 22; - 4; 32) returns -4.

MIN only accepts numbers, or number arrays. Use MINA instead of you also need to evaluate logical values and text strings representing numbers. Use MINIFS to only consider values satisfying one or several conditions.

Examples

MIN (4, 22, - 4, 32)

MIN (4; 22; - 4; 32)

Returns -4.

MIN (4, 22, - 4, BLANK (), 32)

MIN (4; 22; - 4; BLANK (); 32)

Returns -4. Blank values are ignored.

MIN ({ 4, 22, - 4, 32 })

MIN ({ 4; 22; - 4; 32 })

Returns -4. Arrays are supported.

MIN (4, 22, { - 4, 32 })

MIN (4; 22; { - 4; 32 })

Returns -4. Arrays mixed with regular numbers are supported.

MIN (4, 22, { BLANK (), - 4, 32 })

MIN (4; 22; { BLANK (); - 4; 32 })

Returns -4. Arrays mixed with regular numbers are supported. Blank values are ignored.

MIN (First, Other...) MIN (First; Other...)

First

The first temporal value or array of temporal values.

Other

Additional temporal values or arrays of temporal values.

Returns

Temporal Temporal

The earliest of the given temporal values.

Returns the earliest of the given temporal values. MIN (StartDate, EndDate) MIN (StartDate; EndDate) returns whichever of the two dates is the earlier one.

This overloaded function accepts temporal values, or arrays of temporal values. Use MAX instead to obtain the latest of a number of temporal values.

Examples

MIN (StartDate, EndDate)

MIN (StartDate; EndDate)

Returns whichever of the two dates is the earlier one.

MIN ( DATE (2024, 1, 1), DATE (2024, 6, 1))

MIN ( DATE (2024; 1; 1); DATE (2024; 6; 1))

Returns a temporal value representing January 1, 2024.