MAX

Excel Functions

Get the largest value

Syntax

EXCEL

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

Arguments

Parameter	Description
`number1`	Number, reference to numeric value, or range that contains numeric values.
`number2`	[optional] Number, reference to numeric value, or range that contains numeric values.

Return Value

The largest value in supplied data

Details

The MAX function returns the largest numeric value in the data provided. The MAX function can be used to return the largest value from any type of numeric data. For example, MAX can return the slowest time in a race, the latest date, the largest percentage, the highest temperature, or the top sales number. The MAX function takes multiple arguments in the form number1, number2, number3, etc., up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MAX ignores empty cells, text values, and the logical values TRUE and FALSE. The MAX function returns the largest numeric value in the supplied data: When given a range, MAX returns the largest value in the range: The MAX function can accept a mix of arguments:

Examples

Basic Example

The MAX function returns the largest numeric value in the supplied data:

EXCEL

=MAX(12,17,25,11,23) // returns 25

Basic Example

When given a range, MAX returns the largest value in the range:

EXCEL

=MAX(A1:A10) // maximum value in A1:A10

Mixed arguments

The MAX function can accept a mix of arguments:

EXCEL

=MAX(5,10)
=MAX(A1,A2,A3)
=MAX(A1:A10,100)
=MAX(A1:A10,C1:C10)

Logical values

The MAX function will ignore logical values and numbers entered as text that appear on the worksheet. However, if such values are provided directly as

EXCEL

=MAX(-1,TRUE) // returns 1
=MAX(-1,TRUE,"3") // returns 3

MAX

Syntax

Arguments

Return Value

Details

Examples

See Also