Min and Max Function in Excel | Functions in Excel | Excel Tutorial Formulas | Learn Excel

Показать описание

"MS-Excel" provides us users an easy way to compare values in our problem statement. We can determine the "maximum" value and the minimum value present in the "excel" sheet. For this we have predefined formulas in Excel that enable this function.
Let us first study about "maximum function".
The syntax for defining the maximum function is MAX (value)
As we have already learnt previously, the cells are referred to by their cell name (That is either done by cell reference method or point-click method).
Let us start with an easy example, suppose There were two kids A and B who both had their own share of apples . If A had 10 apples and B had7 apples, now if we were to determine who has more number of apples, we could simply use the maximum function. To write this function, simply click on the cell where the desired output is to be displayed and write the function as follows:
define the MAX keyword, then open a Round bracket, then type in the two cell values B2,B3, then close the round bracket. It is simply as MAX(B2,B3).
Now to study about minimum function, let us consider the following example:
suppose Both A, and C are three kids who have some set of flowers with them. Say A has 3 roses, B has 7 roses and C has 1 rose. Now to determine who has the least number of roses, we can simply define the minimum function. The function for this example is to be defined as follows:
define the MIN keyword, then open a Round bracket, then type in the three cell values B2,B3, and B4, then close the round bracket. It is simply as MIN(B2,B3,B4).
Now consider another example, supposedly, we have purchased a list of items in the super market and want to determine the item that was the most expensive amongst the list of items we have bought, we can simply use the Max function.
The list of items is written under column A and their prices in column B as follows.
The formula is written as MAX then Open a round bracket "(", then type in the cell names followed by the comma operator and then close the round bracket ")".
It can be written as MAX (B2, B3, B4, B5, B6) or simply MAX (B2:B6). The colon ":" signifies that the rows within the specified range are included.
Likewise, to determine the least expensive item in the list, we can use the Minimum function.
The syntax for minimum function is MIN (value).
For this example, the function is written as MIN (B2,B3,B4,B5,B6) or simply MIN (B2:B6).
Thus, we can compare any number of values in the sheet and calculate our results with ease.

Рекомендации по теме

Комментарии

This is really helpful. Thank you so much.

amadubenmansaray

It helped me a lot my brother. Thanks much

bennykombab.

Thank you I understood the lecture in an easy way .

chintapallihemalatha

Thank you so much sir I have understood max and min function from ur video

pinashgamango

Thanks for this info brother, it was quite easy. Keep up the great work.

hamzaansari

Omg dude thx so much I had an exam and this really helped me :)

Someone

Voice crystal clear, easy to understand... Thanks

thangaveluraj

I need help, I’m creating a time weekly timesheet in which if any employee goes over 8 hours in a day is over time, so I need to create a column where it adds regular and another only the OT. How do I add the cells to add only 8 hours or less and in the other column anything that is higher than 8 hours.
If you could help me I really appreciate it.

cilor

Hi Dear, Thanks for the video. I have a quarry. If I want to make .6=1, it increases like .1, .2, .3, .4, .5 when it's .6 it makes 1.0. like and next Stape is 2 in one cell? how can I make it?

AaAbid-sprd

Good ilove excel and its work stuff

hussainabbas

How can i make it give me the value as the letter A?

amkh-_-

What about, let's say a calculated value should not be less than the lowest limit and not more than the highest limit? How do we apply the MIN and MAX functions? This is to illustrate what I mean. Calculated value = 90, Lowest Limit = 40, Highest Limit = 85. Thanks in advance for the reply

gnidnoeled

Sir,
A B C
20 40 30
(10) 50 [60
20 30 20
50 10 10
60 10 80
30 (90) 50]
20 20 70
From column A min value 10 to column b max value 90, how can I add column c all cells from min value to max value at column A to column B.

harsinchh