Home
Office 2010 Tutorials
Excel 2010 Tutorials
Word 2010 Tutorials
PowerPoint 2010 Tutorials
Excel 2007 Tutorials
Word 2007 Tutorials
PowerPoint 2007 Tutorials
Video Training : Basic
Office 2007 Tips
Video Training : Tricks
Outlook 2007 Tutorials
Excel 2003 Tutorials
Word 2003 Tutorials
PowerPoint 2003 Tutorials
Outlook 2003 Tutorials
Office 2003 Ebooks
Free Office Templates
Free E-Books
Free Clip Arts
Free Newsletter
Free Tips and Tricks
Keyboard Shortcuts
Windows 7 Tutorials
Win Vista Training
MS Office - How To ?
Google Docs
MS Office Software
MS Publisher
Resources Page
Site Map
Contact Us
Privacy Policy

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines
 


Excel MIN Function


The Excel MIN function is used to find the smallest value in the selected range of cells or a given list of arguments. Text and blank entries are not included in the calculations of the MIN function.

The syntax for the MIN function is:

=MIN (Argument1, Argument2, ... Argument30)
Argument1, Argument2, ... Argument30 can be numbers, named ranges, arrays, or cell references. Up to 30 arguments can be entered in Excel 2003.

To use the MIN function (an example)

  • Enter the following data into cells B1 to B5:

    Excel MIN function data



  • Click on cell B7 where the results will be displayed.
  • Type =MIN(B1:B5) in cell B7.
  • Once finish, press the Enter key on the keyboard.
  • The answer 2177 appears in cell B7 which is the smallest number in the list.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    >> Next Topic : Use Excel MAX( ) Function to Find the Largest Number in a List
    << Previous Topic : What you can do with Excel AND( ) Function?


    You're viewing the Excel MIN Function info page, click here to go back to the Home Page


    Microsoft Windows, Microsoft Office Word, Excel, PowerPoint, Access, OneNote,
    Outlook and Publisher are either registered trademarks or trademarks of
    Microsoft Corporation in the United States and/or other countries.

    Copyright © www.msoffice-tutorial-training.com All rights reserved.
    		•