MAX()

MAX()

Top  Previous  Next

 

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

 

 

Format

 

MAX(a, b)

 

where

 

a, bare the two values to be compared.

 

 

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()