How to: |
The MAX and MIN functions return the maximum or minimum value, respectively, from a list of values.
{MAX|MIN}(value1, value2, ...)
where:
Returns the maximum value.
Returns the minimum value.
Numeric
Are the values for which the maximum or minimum value is returned. If you supply an expression, use parentheses as needed to ensure the correct order of evaluation.
Note: MAX and MIN do not use an output argument. The format of the result is floating-point double precision.
MIN returns either the value of ED_HRS or the constant 30, whichever is lower.
MIN(ED_HRS, 30)
For 45.00, the result is 30.00.
For 25.00, the result is 25.00.
iWay Software |