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.
Now let’s see the practical use of MAXIMUM function:
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.