Function Description
| Category | Description |
|---|---|
| Syntax | MIN(number1,number2,...) |
| Function | Returns the minimum value in the parameter list. |
| Parameter | number1, number2, ...: 1 to n values from which the minimum value needs to be found |
| Number of Parameters | Unlimited |
| Parameter Types | Numbers, logical values, and text expressions of numbers |
| Return Value Type | Number |
| Notes | If parameter values include unsupported types, MIN returns the #VALUE! error. |
Examples
| Formula | Result |
|---|---|
MIN(1,4,10,-1,5) | -1 |
MIN(true,false) | 0 |
MIN(true,1+2) | 1 |