MAX()

The MAX() function returns the greater of two values.

Format

MAX(a, b)

where

The MAX() function compares the values a and b, returning the greater value. If either value cannot be treated as a number, a character by character comparison from the left end is performed until a difference is found, returning the "alphabetically last" item.

Example

A = 6

B = 8

C = MAX(A, B)

C will be set to the greater of the values in A and B, in this case 8.

See also:

MIN()