MIN function

Returns the smallest number in a set of values.

Syntax

MIN(number1,number2,...)

Number1, number2,...     are 1 to 30 numbers for which you want to find the minimum value.

Remarks

  • You can specify arguments that are numbers, empty, logical values, or text representations of numbers. Arguments that are error values or text that cannot be translated into numbers cause errors.

  • If an argument is a column reference, only numbers are used. If logical values and text should not be ignored, use MINA instead.

  • If the arguments contain no numbers, MIN returns 0.

Examples

Col1

Col2

Col3

Col4

Col5

Formula

Description (Result)

10

7

9

27

2

=MIN([Col1],[Col2],[Col3],[Col4],[Col5])

Smallest of the numbers (2)

10

7

9

27

2

=MIN([Col1],[Col2],[Col3],[Col4],[Col5],0)

Smallest of the numbers and 0 (0)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×