Min Formula in Excel
Hello everybody! And welcome to excel made easy!
I’m your Excel Guru and today I have come up, I brought a new formula for you called Min M IN and MIN does, what it does it finds out the lowest value or the smallest value in a given range. Alright so this formula starts with, let’s see how to use it. Is equal to M I N Min and in Excel 2007 and above it’s a good feature that all the formulas related to the spelling you typed in would show up over here so all you need to do is just press tab and the formula would, the parenthesis sign would automatically come in. Ok so bracket open and select your lowest marks, lets select history this is the example I have taken, names of the students, marks in English, marks in history and all that thing.
So well let’s go to history, my pain point also. I also used to get the lowest marks over here. So close the bracket and the lowest marks in history was achieved by student who has got only 40 marks. Ok name is Caril Davis, luckily it’s not me. So this is what MIN does and it also works on negative values say for example if we edit it and also enter a minus sign over here so it automatically changes to minus. Now sometimes while doing a formula you may require to have the lowest value which might be a minus figure but without the minus sign. That is a possibility so you can club the min formula with ABS.
How it would be done. is equal to is equal to abs bracket open M I N bracket open your range bracket close bracket closed again and answer, so again you got the lowest answer which is 40 however without the minus sign. So this was the min formula. It can be done in another manner also and how you have to click the formula tab, insert function, type in MIN and then click on go and here comes Min. Let’s see what Excel has to say, returns the smallest number values in a set of values, ignores logical values and text, so we select a range this is how we do it select a range click ok and here is your answer.
Returns the smallest number in a set of values.
MIN(number1, [number2], …)
The MIN function syntax has the following arguments:
- Number1, number2, … Number1 is optional, subsequent numbers are optional. 1 to 255 numbers for which you want to find the minimum value.
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- Logical values and text representations of numbers that you type directly into the list of arguments are counted.
- If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
- If the arguments contain no numbers, MIN returns 0.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
- If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.
So the training file you are looking at in this video is available for free download at my website ExcelMadeEasy.weebly.com and lets go to this website, where is it, here it is. This is my website. You can go to the training file page and download, download the training file. You can also watch my videos from here. These are my playlist for my fans in India, Pakistan, Bangladesh, Nepal. It’s a Hindi playlist and for people abroad other than in Non Hindi speaking countries, English speaking countries, sorry, this is my English playlist and if you believe that what my what I am doing is right and should be shared with the others also then I would request you and ask you to follow me on Twitter. Click on this link and it will take you to my Twitter page. You can follow me over here. Once you start following me, you’ll be getting my tip of the day.
Every day I give a tip on Microsoft Excel and also you’ll be able to recommend my work to other people and that will be equivalent to sharing knowledge. You can also login to my Facebook page from my, my website itself by clicking over here, it will take you to my Facebook page where in you can like us over here and once you like and then you’ll be able to share this work with other and share knowledge. Also the work you are looking at, the video that you’re looking at, is available on my YouTube page which is Excel Made Easy. So what you need to do is, what you can do is, you can subscribe over here, click on the subscribe button over here so that whenever you like to search me on YouTube it will be very easy for you and whenever I upload a new video you’ll be updated on that also
So this is your Excel Guru signing off for the day
Have a wonderful day ahead !
Happy Excel learning!