June 18, 2021

# 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:

Syntax: =MAX(B8:B15)

Result:

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

Syntax: =MAX(B2:D9)

Result:

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:

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

Result:

READ:  How to use now function in excel

#### Excel

View all posts by Excel →