# MAX

The MAX function returns the largest number in a set of values. Cell references are also accepted as arguments.

### Syntax <a href="#syntax" id="syntax"></a>

```excel-formula
max(value1,[value2]....)
```

### Arguments <a href="#arguments" id="arguments"></a>

value1 - The numbers or names, arrays, or references that contain numbers. This is a required argument.

value2... - The numbers or names, arrays, or references that contain numbers. This is an optional argument.

### Example <a href="#example" id="example"></a>

```excel-formula
max(COLUMN1,COLUMN2,COLUMN3)
```

Returns the maximum of COLUMN1, COLUMN2 and COLUMN3

### Excel Equivalent <a href="#excel-equivalent" id="excel-equivalent"></a>

[MAX](https://support.microsoft.com/en-us/office/max-function-e0012414-9ac8-4b34-9a47-73e662c08098)