MIN()

MIN()

Top  Previous  Next

 

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

 

 

Format

 

MIN(a, b)

 

where

 

a, bare the two values to be compared.

 

 

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