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