MIN
Calculates the minimum value of specified numbers.
Syntax
=MIN(number1, number2, ..., numberN)
=MIN(numberArray)
Arguments
| Argument | Type | Description |
|---|---|---|
| number | Number or Array | A number or array of numbers to find the minimum of |
If an array of values is supplied, the array will be flattened when averaging. For example,
=MIN(ARRAY(1,ARRAY(2,3)),ARRAY(4,5),6)returns 1.
Examples
=MIN(1,2,3) → 1
Calculates the minimum of 1, 2, and 3.
=MIN(ARRAY(4,5),6) → 4
Calculates the minimum of any array containing 4, 5 and the number 6. Because the MIN function flattens arrays, this is the same as the minimum of 4, 5, and 6.
=MIN(children."Property 1") → 1
Calculates the minimum of all children's data property values for "Property 1" (1, 4, 2, 6, 7, 8).
Updated 8 months ago