Spread 8.0 Documentation
MIN
Support Options
Formula Reference > Built-In Functions > MIN

Glossary Item Box

MIN


Name

Minimum value

Description

Returns the minimum value of all arguments.

Syntax

MIN(value1, value2, . . . )

Remarks

Accepts up to 30 arguments. Each argument can be a cell or cell range, a float value, or an integer value.

See also MAX.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

MIN(R1C2,R3C5,R4C7,R6C7)
MIN(A3,B5,C1,D4,E7)
MIN(A1:A9)
MIN(2,15,12,3,7,19,4)=2

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.