# Excel MAX Function

This post will guide you how to use Excel MAX function with syntax and examples in Microsoft excel.

## Description

The Excel MAX function returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array.

The MAX function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.

The MAX function is available in Excel 2016, excel 2013, excel 2010, excel 2007, excel 2003, excel XP, excel 2000, excel 2011 for Mac.

## Syntax

The syntax of the MAX function is as below:

`= MAX(num1,[num2,…numn])`

Where the MAX function arguments are:

• num1 -This is a required argument. A number, or a reference to a number or a range that contains numeric values
• Num2,…Numn – This is an optional argument.  A number, or a reference to a number or a range that contains numeric values

Note:

• The num1 arguments can be numbers, arrays, defined names or references that contain numeric values.
• IF the arguments contains non numeric value, it returns 0.
• The value returned by the MAX function is still a numeric value.
• If the argument is an array or reference, only numbers in that array are used. Empty string, logical values or text of numbers are ignored.
• You can provide up to 255 number arguments in excel 2007 or later. If you are using excel 2003, you can only provide up to 30 number arguments.

## Excel MAX Function Examples

The below examples will show you how to use Excel MAX Function to get the largest value form the numbers in a range.

#1 To get the largest value from a range B1:B4, just using the following excel formula:

`=MAX(B1:B4)` ### You might also like:

Sidebar 