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: