Name

min — Returns the smallest value in a set of values.

Syntax

min(number1, number2, ...)
                

The MIN function has the following arguments:

number1

The first number in the set of numbers to be scanned for the minimum

number2

The second number in the set of numbers to be scanned for the minimum

...

Additional numbers in the set of numbers to be scanned for the minimum

Description

The min function returns the minimum value in a set of numbers. At least one value must be in the list, otherwise there is no limit to the number of values in the argument list.

The value returned will be an integer if all of the numbers are integers. The value returned will be a number if any of the values in the argument list are numbers.

Examples

Formula

Description

Result

min(1,2,3)

Choose the minimum integer

1

min(6.3, 12.2)Choose the minimum number6.3
min(8.5, 200, 5)Choose the minimum number5.0