MIN()

The MIN() function returns the lesser of two values.

Format

MIN(a, b)

where

The MIN() function compares the values a and b, returning the lesser 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 first" item.

Example

A = 6

B = 8

C = MIN(A, B)

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

See also:

MAX()