One of the most outstanding aspects of this microsoft program is that it has a large number of functions that will allow you to carry out different types of activities especially those related to numeric data, as they are mathematical or calculus operations.
In this case we are going to teach you a little more about what What are the MIN and MAX functions? two very important tools when working on the program since each of them will allow you to know what are the maximum and minimum values of your .
Accordingly, here we are going to explain a little more about how you can start use each of themSo as the exact operation of each. To do this, follow in detail everything that we will teach you next in the post.
What are the MIN and MAX functions and when is it necessary to apply them in Excel?
These two functions are very necessary at the time of work in excel spreadsheetand it is that they have as its main function to help you find certain values.
In the case of the MIN function it will provide you the minimum value of a list of valuesexcluding the text and logical values.
As an argument of the function you can enter the numbers that you want to evaluate or simply a range or the reference of one that contains the numerical values.
In this type of function, the following aspects that we name below can be considered:
- are taken into account logical values and written number texts directly in the argument list.
- The arguments can become so names, arrays, number or references containing numbers.
- In the case that the arguments do not contain any number then the MIN function returns 0.
- In the case that the argument is a reference or an array, it will be used only numbers that are contained in either the array or reference. What they are empty cells, texts contained in references or arrays, and logical values will be ignored.
- If they exist error values or text that cannot be translated into numbers will simply generate an error.
Taking all these aspects into account, here we are going to leave you an example of what the MIN function is so that you can understand it a little better:
- In the following table you can see a variety of items where you want to get what is the minimum valueif it is done manually, it may be a long and tedious procedure, especially if there is a lots of values. The objective of the MIN function is to simplify all these chores and save time so that the user can work more efficiently.
- How can see in the picture each of the items has selected the minimum value of the selected row.
While the MAX function it will allow you to get the maximum value of a set of values either one list of numbers located in one or more ranges of the spreadsheet. In this way, the function allows you to return the maximum value of a set of values.
Regarding this function, the following aspects can be mentioned to take into account:
- The arguments can be numbers, matrices, names or references containing numbers.
- In the case that the argument is a array or a reference, only the numbers contained in them will be used. Therefore, all empty cells, logical values and texts will be ignored.
- are kept in mind the logical values and textual representations of numbers written in the argument list.
- if for some reason the argument contains no numbers the MAX function returns 0.
- Arguments that are values of error or text that they cannot be translate to text will cause an error in the result.
According to all this, here is an example of this tool so that you can better understand how it works:
- In the following table we will present a data series where you only want to get the MAX value of each row. If done manually it can end up being a long and tedious process to perform. For this you can make use of what is the MAX function which is in charge of facilitating all this operation.
- As seen in the image, ceach of the rows has its maximum value selected, This could be achieved by applying the max tool. Therefore, putting into practice these two functions will allow you to work more easily and in a much faster way, thereby saving time.
Learn step by step how to perfectly apply the MIN and MAX functions in Excel
Bearing in mind all of the above, now we are going to explain step by step how you can start applying these two functions in each of your Excel tables.
Keep in mind that this procedure is very simple to carry out, to do so, follow each of the methods that we will indicate below:
Minima
To apply this function in your Excel spreadsheet you must perform the following steps:
- The first thing you should do is create your data table in excel. In this case, a table with the names of the sellers and the amount of money that they got for sales in the months of January, February and March.
- The first piece of information you need to have is the minimum value for the month of Januaryin this case the following should be applied formula: =MIN(B2:B9).
- As you can see the formula returns the result of $304being this the lowest value of said column.
- Now if you want to know the lowest value of the quarter you can use the following formula: =MIN(B2:D9).
- In this case the range of the value B2:D9 encompasses what they are the columns of the three months. As can be seen at the time of apply the formula its thrown the result of $112being this the minimum sale value of the three months.
- In case you want to know the minimum sale value of some of the specific vendors you would simply have to place the range of the cells of the months of that seller. In the case of Ruth’swas the next function: =MIN(B8:D8).
- As can be seen in imagehere it is automatically shown which was Ruth’s lowest sale in the first quarter of the year.
highs
In the case of the MAX function is applied in a way similar to MINbut this time it is done with the aim of getting the maximum values in the table. In this case it is a table of employees but this time with sales profits for the first four months of the year.
Therefore, the first thing will be to know that seller made more profit in the month of February, For this, the following formula must be applied: =MAX(D3:D10).
In case you want to know what was the seller who sold the most in the first four months of the year then the following formula should be applied: =MAX(C3:F10).
In this way you can know what are the maximum values of your work table in Word, this will allow you save you a lot of time when you need to know certain values and you have a very large data table.
Facebook Comments
Disqus