How to use Max Function in Excel

Maximum value calculation can be helpful in many use cases. There can be a need to find maximum spend, or maximum transactions, or maximum salary etc. Max function helps maximum value calculation in Microsoft Excel. Max function is one of the frequently used function along with Sum function. How to use Max Function in Excel? learn in easy steps with the help of this article.

John has customer spend data for his company. He is looking foward to calculate maximum spend for all the customers. He is also looking forward to calculate maximum spend for specific customers, 1, 2 and 4. We will look into both the examples.

Calculate Maximum value for Entire Column in Excel

To find maximum value for all the values in a column, below syntax helps:

=MAX(J5:J24)

Here, this formula helps in finding the Maximum of all the values from J5 to J24 (i.e. J5, J6, J7 …. J24). You can see below, with the help of the formula maximum value is obtained easily.

To get top certifications in Microsoft Excel and build your resume visit here. Also, you can read books listed here to build strong knowledge around Microsoft Excel.

How to find Maximum value of random cells in Excel

In the second example, we are trying to find maximum value of some random cells. Here we are trying to find maximum value of Yearly spend of Customer ID 1, 2 and 4. These corresponds to cell number J5, J6 and J8. Below is the formula that will help to achieve the results.

=MAX(J5,J6,J8)

This calculates the maximum value of some random cells. To achieve more such calculation, cells can be added along with comma separators. Below is the formula results.

Please visit our video tutorial to go through the example as well:

Share your feedbacks if you like the article. Like and share for more such content.