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.

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

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!

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!