MIN(<List>)

 

Description

This function returns the minimum of its arguments.  Blank cells and cells containing strings are ignored.

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

MIN(4, 56, 33, 100, 0, -1) = -1

 

MIN(S3:S7) = -99

Where S3:S7 = -1, -4, -99, -20, -1.5.

 

MIN(A1:B2) = -93

Where A1 = 0, A2 = -93, B1 = 93, and B2 = 7.