MAX Function in excel and how to use?

Untitled design

Author: Sarthak Bhalerao

Table of Contents

  1. What is the Max function in Excel?
  2. How does the Max function work?
  3. Example

What is the Max Function in Excel?

The Max function is categorized under Excel Statistical function. MAX will return the largest value in a given list of arguments. In financial analysis, the MAX function can be very useful in calculating the highest score, the fastest time, or highest revenue or expense, etc. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MAX function can be entered as part of a formula in a cell of a worksheet.

How does the Max function work?


  • Syntax:

          MAX( number1, [number2, …… number_n])


  • Parameters:
  1. Number1 – IT can be a number, named range, array, or a reference number
  2. Number2 – These are numeric values that can be numbers, named ranges, arrays, or references to numbers. Maximum values are 30. This is optional.


  • Returns:

          The MAX function returns a numeric value


  • Applies to:

          Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003,                Excel XP, Excel 2000


Let us calculate the highest marks from the following data:



The formula used was:



As seen above, MAX will ignore empty values. In this example, if we provide a logical value, the function will ignore it and give the result, as shown below:


Leave a Reply