How To Use The MIN Function In Excel - Yes Edu

Hot

Make Money

Monday, 31 October 2016

How To Use The MIN Function In Excel

Microsoft's Excel program allows you to build spreadsheets with mathematical formulas that adjust data according to your instructions on an ongoing basis.


In this artical we describes the Formula syntax and usage of the "MIN" function in Microsoft Excel. 


Open Microsoft Excel on your Computer.

     1. Click On :New" at the left side
     2. And click on the "Create" button at the Rightside



Enter information and Data in the cells that you will Wan the "MIN" of.



  • Enter the numbers in cells B2 through B13 of the worksheet.
  • the number enter are  32, 53,44, 33, 45,66, 16, 65,54,34,34, and 41 



Entering the formula “=SUM(B2:B13)” in cell B14.


Hit "Enter" to See the Result.




Enter the "MIN"  to find the Minimum value of the number you Enter.




You can place the "MIN" function in many ways, Due to the "MIN" fuction you can find the Minimum  value in the dsire sheet.
  • Click on an empty cell, such as B1,7 then type “=MIN(B2:B13)”  And Click Ok.
  • Click on any Empty cell Enter the range “B2:B13" and Click Ok.




Hit "Enter" to see the Minimum Value in the Result

















No comments:

Post a Comment

Post Top Ad

Your Ad Spot