Formula (Extended): $MIN Function
Overview¶
Find the minimum value of the arguments.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Num1 | Half-width numerical value | Required | The first number for which the minimum value is to be found. |
| [Num2],... | Half-width numerical value | Optional | Additional numbers for which the minimum value is to be found. |
Column Usable as Parameters¶
| Parameter | Classification | Numeric Value | Date | Description | Check |
|---|---|---|---|---|---|
| Num1 | Yes | Yes | No | Yes | No |
| [Num2] | Yes | Yes | No | Yes | No |
Return Value¶
The minimum value of the arguments.
An error will occur if an error value or a string that cannot be converted to a numerical value is specified as an argument.
Return Value Display Content¶
| Target | Display Content of Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display return value. If the drop-down list has values, displays options that match the values. |
| Numerical Value (including work volume, progression rate, remaining work volume) | Display return value. |
| Date (including start and completion) | Do not display. |
| Description (including content) | Display return value. |
| Check (including lock) | Do not display. |
Usage Example ①¶
Specify parameters by screen column name (name displayed)
Formula¶
Parameters¶
Calculation Result¶
