Excel MAX Function

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


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.


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


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


excel max function example1

Related Examples

Related Posts

Basic Array Formula With Examples

Are you searching for an article for getting the basic array formula with different examples for better understanding? Then congratulations because you have just landed on the right article. In this article, you would get to know the basic array ...

Extract all the matches with helper Column

With Excel's powerful functions IF, INDEX, and MATCH, we can find exactly what you're looking for with a few clicks of the mouse. This step-by-step tutorial will show how easy it is to extract data using these tools and more! ...

How to Find the Earliest and Latest Date in Excel

We have a range of dates and we want to look up the earliest and the latest date based on certain criteria like the earliest date for a showing movie, we can use MIN and MAX functions with IF function ...

How to Create Dynamic Drop Down List without Blank in Excel

This post will guide you how to create dynamic drop down list without blank cells in Microsoft Excel. In Excel, and you can use Data Validation feature to improve the efficiency of data entry in excel, and it also be ...

How to Calculate the Average Excluding the Smallest & Highest Numbers in Excel

Calculating the average for a batch of data is frequently used in our daily life. But for some cases like statistic the average score in a competition, or price analysis, we often calculate the average excluding the smallest and highest ...


So empty here ... leave a comment!

Leave a Reply