Author: Oscar Cronquist Article last updated on April 19, 2018

The MAX function allows you to calculate the largest number in a cell range.

The formula in cell D3 extracts the highest number from cell range B3:B10, see picture above.

Excel Function Syntax

MAX(number1, [number2], ...)


number1 - You need at least one argument. Required.

[number2] - Up to 254 arguments are possible. Optional.


Arguments can be constants, named ranges, cell references and arrays.

The MAX function ignores text and boolean values, however not errors.