How to use max function in excel

Excel MAX function is categorized under statistical functions in Microsoft 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.

Syntax: = MAX(number1, [number2], …)

The MAX function syntax has the following 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.

MAX in Excel Example #1: For example, to get the highest value in the range B8:B15, use this simple formula:

max function - How to use max function in excel

Syntax: =MAX(B8:B15)

Result:

excel max function 1 - How to use max function in excel

MAX in Excel Example #2: For example, to get the highest value in the range B2:D9, use this simple formula:

excel max rows 1 - How to use max function in excel

Syntax: =MAX(B2:D9)

Result:

max function excel - How to use max function in excel

MAX in Excel Example #3: For example, to get the highest value in the range B3,B6,B8,C2,C5,C9,D3,D5,D8, use this simple formula:

excel max rows 1 - How to use max function in excel

Syntax: =MAX(B3,B6,B8,C2,C5,C9,D3,D5,D8)

Result:

max function excel 1 - How to use max function in excel

Add a Comment

Your email address will not be published. Required fields are marked *