# MIN

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the minimum value, the least value, of all the values in the arguments.

## Syntax

MIN(*value1*,*value2*,...)
MIN(*array*)
MIN(*array1*,*array2*,...)

## Arguments

Each argument can be a double-precision floating point value, an integer value, or an array of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

## Remarks

If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.
This function differs from [MINA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMINA), which includes text and logical values as well as numeric values.

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

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

## Version Available

This function is available in product version 1.0 or later.

## See Also

[MAX](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMAX) \| [MINA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMINA) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)