Related Topics:

Spreadsheet Mathematical Functions

Function Wizard 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, ...)

Remarks:

Example:

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

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.