MAX function in Excel

MAX Function | Max Formula in Excel

This tutorial will explain us about the use of MAX function in Excel. Max function is used to find the maximum or the largest value in the cells. This function helps us to locate where the maximum data is located in the spreadsheet. In 2003 version only 30 arguments could be provided. However in the 2007 version and later 255 arguments can be provided.

Syntax or Formula of Max function in Excel:

The formula to find the Max value in the spreadsheet is

=MAX(number1, [number2]…) where number stands for the range of cells you want to find the maximum value of.

The Max function is an in-built function in Excel. It is categorized as Statistical function in Excel. It is known as worksheet function because it is used to carry out the operations in the worksheet.

NameAmount
John14500
Chris17000
Shaw13700
Jordan16000

In the above table we need to find the Maximum amount that is paid to a person. To find this we will enter the Max formula in the empty cell and enter the range in that cell. We will get answer as 17000.

Notes To Remember: 

To carry out Max function we must keep the following points in mind.

1. MAX Function ignores empty cells.

2. If MAX Function does not contain arguments than it will show the return value as 0.

3. Arguments must contain numbers or reference to numbers.

4. MAX Function ignores logical values and True and False Values.

Where is MAX Function in Excel?

Max function is found at 2 places in the Ribbon.

The first place is in the Home tab ribbon > Editing group > AutoSum drop down > Select Max.

The second place is in the Formula tab ribbon > Functional Library > Statistical function > Select Max.

Conclusion

You have seen above how the Max function works in the spreadsheet. It helps you to get the greatest return in the spreadsheet. The video will help you know more about its use in Excel.