The next two functions that we are going to take-a-look at here are pretty common as well. Perhaps not as common as some function but you are going to see these two pretty often inside of Excel documents. We are going to look at the built in Min and Max functions two very similar functions, and in fact they are going to look very similar in structure number in the three parts equals function name arguments very similar to the sum function.
I am back exercise file (Mothly Budget). Hopefully you have taken a moment to go through and practice at some function and complete it for the rest of the months and for your road totals as well for each of the bills.
Now if you have got any questions on the SUM function or functions in general. Jump into the Review section and ask your questions, I love getting questions ask them.
Min and Max to get this set up.
I am going to go into row 11 and I am going to put in some labels here these labels. That is all they are going to be just labels to label our calculations.
The first one that we are going to experiment with here is the main function. And like I said this should feel pretty similar to working with some function that we saw earlier, I want to know the minimum value from a range of cells smallest value.
I am going to go to B11 going to go to formulas tab, we can look at our little books. Earlier we went into math and trig. We wanted to do some math type operation we wanted to some. We found it here inside of the math function or the math folder little book by scroll on through.
I find the, but I do not see the MIN or the MAX inside of there. So I am not inside of there.
We got all these other books that we can look through as well. We have got financial logical text date time lookup and reference, Where do you find the MIN MAX function.
Let us see there is one called more functions, If I go into there there is statistical engineering cue the information compatibility and so on.
I really guess statistical, If I scroll through here I will find MIN MAX in function.
I know is there because I have been using this application forever. where do I find it, How do I know where to find this thing at.
We can use the books and as you become more and more familiar with working set of excel where functions reside .
Eventually you are going to be typing them out by hand anyways, You may not even go to the formula tab.
Here I am going to go click that little fx button, click on it I get the insert function window where I can search I can type in keywords I can search by category and down below, They’ll give you suggested functions for that search term or that category.
Here I could say I want to find the MIN function, I will type that in or you type in minimum or whatever then I will hit Go
Took them all with their recommended and that is giving me some suggested or recommended functions.
The MIN function returns the smallest number in a set of values ignores logical values and text, looking for minimum values of numeric values.
With MIN selected, I will hit OK. And this opened up the argument window of MIN function, It is already filled in some information for me.
Let us take a closer look at that B4 through B10. Well I do not really want that I won’t B4 through B10 , Excel tried to help me but B10,B9 is empty and B8 is my total. I do not want include the total. So I am just going to wipe that out (Delete).
Then I will go grab before through B4 to B7.
Then click OK
Returns the smallest number in a set of values. And for the month of January 125 is my smallest
This is going to be almost identical with MAX function
I am going to drop down one more cell and to B12 where I have got the Max, I am going to do the same thing.
I am going to go back to fx icon, I will type in Max -> Go
That was my recommended I am going to grab Max.
Click -> OK
Delete default value in Number1 box, then select cell B4 to B7 by mouse
Final click OK, And I have got my maximum value.
Min and max two more predefined functions built into the Excel application, already built for us.
We just got to use it. Put in the range of cells that we want and it is done the job for us. So try it out, then also do it for the rest of the months. Get all these cells filled out with your Min, Max. And if you want to do it for the total or for the percentage, Feel free to do it there as well.