Returns the minimum value in the selected line items.
It can also be used as an aggregation function, see x[MIN:y].
Syntax
MIN(x,y,[z])
where:
- x: Number or date to compare
- y: Number or date to compare
Format
| Input Format | Output Format |
|---|---|
|
x: number or date y: number or date |
Matches the data format used by argument x |
Arguments
The function uses the following arguments:
- x: number-formatted or date-formatted line items
- y: number-formatted or date-formatted line items
Constraints
The function has the following constraints:
- At least two arguments must be passed.
- The result formatting must match the source formatting.
Excel equivalent
Example
A number-formatted Minimum Monthly Costs result line item uses MIN against six number-formatted source line items:
A text-formatted Earliest Accounting Date result line item uses MIN against three date-formatted source line items:
