How to use MAX function in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/statistical/excel-max-function.html
SHARE




In this article, we’ll learn about MAX function in Microsoft Excel.

In Excel, MAX function is used to find the largest or maximum number from a range of cells.

image 1

With the help of examples, let us understand the use of MAX function in Excel.

Refer to these 5 different examples for the usage of MAX function in Microsoft Excel on the basis of following sample data:

image 2

 

1st Example:-

We have a range of numbers from which we want to retrieve maximum numbers.

image 3

 

Follow below given steps:-

  • Enter the function in cell A14
  • =MAX(A8:A12)
  • Press Enter

image 4

 

2nd Example:-

In this example let’s see what happens when we enter some value in the function to along with the range.

image 5

 

Follow the steps given below:-

  • Enter the function in cell B14
  • =MAX(B8:B12,15,5*4)
  • Press Enter

image 6

 

  • Function has returned 20 and in the third argument we have entered 4*5 which is equal to 20 which is the largest value amongst the range and the logical values

3rd Example:-

In this example, we will refer to the blank cells in the function range.

image 7

 

Follow the steps given below:-

  • Same, enter the Max function in cell
  • =MAX(C8:C12)
  • Press Enter

image 8

 

By ignoring the blank cells, Max function returns the result on the basis of available value within the range.

4th Example:-

In this example, we will see what happens when text is available within the range.

image 9

 

Follow the steps given below:-

  • Enter the function in cell D14
  • =MAX(D8:D12)
  • Press Enter

image 10

 

We can see in the above image the function has returned maximum available value within defined range. It means MAX function ignores cell that contains text within specified range.

 

5th Example:-

In this example, we have taken error value within range.

image 11

 

Follow the steps given below:-

  • Enter the function in cell E14
  • =MAX(E8:E12)
  • Press Enter

image 12

 

Function has returned the same NA error because it cannot have any error value in the range which we are referring to in the number argument and hence it returns an error as an answer.

So, this is how MAX function works and we can make use of it in different situations.

 

image 48

 

Video: How to use MAX function in Microsoft Excel

 

Watch the steps in this short video, and the written instructions are above the video

 

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at [email protected]

 
 

Please follow and like us:
0


Leave a Reply

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

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>