# MAX

## 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](/spreadjs/docs/v16/formulareference/FormulaFunctions/statistical-functions/MAXA), 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