Table of Contents
Overview
Returns the minimum of the arguments.
Syntax
MIN (n1, n2, n3)
MIN(10,15,25)
| n1, n2, n3 | List of numerical values or arguments. Can have as many values/arguments as required. |
Examples
MIN(FIELDVAL(‘Price’),10)
| Price | MIN |
| 5.00 | 5.00 |
| 10.00 | 10.00 |
| 15.00 | 10.00 |
| 17.50 | 10.00 |
In the example above MIN(FIELDVAL(‘Price’),10) looks at each value in the Price field and compares it to 10 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 so ‘10.00‘ is returned.
MIN(FIELDVAL(‘Price’),10,17)
| Price | MIN |
| 5.00 | 5.00 |
| 10.00 | 10.00 |
| 15.00 | 10.00 |
| 17.50 | 10.00 |
In the example above MIN(FIELDVAL(‘Price’),10,17) looks at each value in the Price field and compares it to 10 and 17 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 or 17 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 but lower than 17 so ‘10.00‘ is returned.