MAXIMUM( ) function

Returns the greater value of two numeric values.

Syntax

MAXIMUM(number, number)

Parameters

number, number

Numeric. The two values to compare, separated by a comma.

Output

Numeric.

Remarks

If the two number parameter values do not have the same number of decimal places, the result is adjusted to the larger number of decimals. For example, the output for MAXIMUM(3.6000,10) is 10.0000. You can use the DECIMALS( ) function to adjust the number of decimals for one or both number parameters.

Examples

Example Return value

MAXIMUM(4, 7)

7

MAXIMUM(7.5, 4)

7.5

MAXIMUM(7, 4.567)

7.000

If you have a table of overdue accounts, to create an Interest_Due field that has a minimum value of $1.00 or greater, specify the following:

MAXIMUM(BALANCE * ANNUAL_RATE, 1)

If the balance multiplied by the interest rate is less than one dollar, MAXIMUM( ) returns 1. Otherwise, MAXIMUM( ) returns the calculated interest amount.

Related reference
MINIMUM( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback