Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

MIN

Description: Returns the smallest number in a set of values. The set can be defined by entering the values separated by commas, or by entering the references for a range of cells. For example, =MIN(1,2,3,4) returns 1 while =MIN(A1:A4) returns the smallest value in rows 1 through 4 of column A.

Syntax: MIN(Number1, Number2, ...)

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

Remarks:

• Arguments can either be numbers or names, arrays, or references that contain numbers.

• Logical values and text representations of numbers that you type directly into the list of arguments are counted.

• If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.

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

• Arguments that are error values or text that cannot be translated into numbers cause errors.

Example:

If A1:A5 contains the numbers 10, 7, 9, 27, and 2, then:

• MIN(A1:A5) = 2 [the smallest of the numbers in the reference]

• MIN(A1:A5, 0) = 0 [the smallest of the numbers including those in the reference]