What is the use of MAX function in Excel?

Data Science, AI and ML
,
#1

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