# What is the use of MAX function in Excel?

The Excel MAX Formula is used to find out the maximum value from a given set of data/ array. MAX function in Excel returns the highest value from a given set of numeric values. Excel MAX formula will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.

• Purpose : Get the largest value
• Return value : The largest value in supplied data

Syntax

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

• Arguments

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.

Example:

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

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

The MAX function can accept values as separate arguments or in ranges or arrays:

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

MAX ignores logical values and numbers entered as text, unless they are provided as arguments:

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