Min Formula Of Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Min Formula Of Excel






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.

Description

Returns the smallest number in a set of values.

Syntax

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.

Remarks

  • 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!








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok