Max Function Excel

Maximum is a widely used function in Excel. Very often we need to know the maximum number of a specific range. Yes, MAXIMUM is the function which can easily show you the maximum number of a range. But this function is very easy to use.

=MAX (NUMBER1:NUMBERn)

Now let’s see the practical use of MAXIMUM function:

Illustration MAXIMUM; Example: 1

Above image shows a simple range of some people’s names and their respective salary. We find the maximum salary of the all-employee is $ 940 by using the formula =MAX(C3:C14) . So, finding the maximum value of a data set is very easy.

Leave a Reply

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