How to Use MAX function in Excel

In this article, we will learn how MAX function works in Excel.
MAX function returns the maximum number is the range.
Syntax:

=MAX(number 1, number 2, ..)

MAX function only considers the numbers
Let’s understand how to add cells in excel 2016 with the example explained here.
Maximum of two input numbers is done via Formula shown below.
Use the formula

=MAX(20,21)

138
Now we wish to find the Maximum from the entire column.
Here we have 76 numbers in column A.
139
Here we need to Maximum value present in this column. There would two methods
Use the formula

=MAX(A2:A77)
OR
=MAX(A:A)

140
As you can see you can get the maximum value from the range of numbers. You can get the minimum value from the range using the MIN function in Excel.

Hope you understood how to get the MAX value using the MAX function in Excel. Explore more articles on Excel number function here. Please state your query in the comment box below.

Leave a Reply

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

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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube