# MAX

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 maximum value, the greatest value, of all the values in the arguments.

## Syntax

MAX(*value1*,*value2*,...)
MAX(*array*)
MAX(*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 [MAXA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMAXA), which allows text and logical values as well as numeric values.

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`MAX(A1,B2,C3,D4,E5)`
`MAX(A1:A9)`
`MAX(R1C2:R1C15,R2C2:R2C15)`
`MAX(2,15,12,3,7,19,4)` gives the result 19

## Version Available

This function is available in product version 1.0 or later.

## See Also

[MIN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMIN) \| [MAXA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMAXA) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)