January 28, 2021

MAX function in Excel

In this lesson we will learn how MAX function works in excel. The MAX function in excel is used to find the maximum value from a set of numbers.

MAX(num1, num2,..)
  • num1 : This can be a numeric value or can be a reference of a cell containing numeric value or a range of cells containing numeric values.
  • num2 : This is optional. This can also be a numeric value or a reference of a cell containing numeric value or a range of cells containing numeric values.

Let’s understand with some simple examples. First we have added the below formula in cell A1 and as you can see, from the set of numbers provided the MAX function returns the maximum value which is 9687.11 here.

=MAX(45,152.86,560,9.038,9687.11,8102)

Now we will see how the MAX function works with cell references. In column A we have cells containing integer, decimal numbers & text values and also empty cell is present there. Now we have added the below formula in cell C1.

=MAX(A1,A2,A3,A4,A5,A6,A7,A8,A9)

Here as you can see the MAX function finds the maximum number which is 9687.11 from the cell references provided and the point to note is, it ignores the text and blank values.

With the same dataset we can also see the MAX function works with cell range as well. We have just changed the formula in cell C1 as follows and the result remains same.

=MAX(A1:A9)

The MAX function also works with multiple cell ranges as arguments. Like in the below example we have added two cell ranges A1:A9 & B1:B10 as arguments in MIN function in cell C1. In both ranges there are numbers, blanks, text, special characters and alphanumeric values. The MAX function finds the maximum number among them which is 214 here.

=MAX(A1:A9,B1:B10)

You can also check here to understand how the MAX function works in Google Sheet.

You can also check here to understand how the MIN function works in Excel.

You can also check here to understand how the MIN function works in Google Sheet.

Leave a Reply

Your email address will not be published. Required fields are marked *