Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: MS Excel Functions Min Function Tutorial

The MIN function in Excel will return the smallest (Min) value in the selected range of cells.

Tutorial Details:

Min Function in excel

The next function we will discuss is Min (which stands for minimum). This will return the smallest (Min) value in the selected range of cells.

Blank entries are not included in the calculations of the Min Function.

Text entries are not included in the calculations of the Min Function.

Lets use the table here for the discussion that follows.

We will look at several different specific examples that show how the min functions can be used!

Example of min
Cells to look at
Ans. min
=min (A1:A4)
A1, A2, A3, A4
10
=min (A2:A3, 100)
A2, A3 and 100
20


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
MS Excel Functions Min Function Tutorial

View Tutorial:
MS Excel Functions Min Function Tutorial

Related Tutorials:

Accelerate your Java apps! - JavaWorld - September 1998
Accelerate your Java apps! - JavaWorld - September 1998
 
Design networked applications in RMI using the Adapter design pattern
Design networked applications in RMI using the Adapter design pattern
 
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
 
Set a window's minimum size? - JavaWorld October 1999
Set a window's minimum size? - JavaWorld October 1999
 
Use the JVM Profiler Interface for accurate timing - JavaWorld
Use the JVM Profiler Interface for accurate timing - JavaWorld
 
Encapsulation is not information hiding - JavaWorld May 2001
Encapsulation is not information hiding - JavaWorld May 2001
 
Create a scrollable virtual desktop in Swing
Create a scrollable virtual desktop in Swing
 
Integrate Java and C++ with Jace
Integrate Java and C++ with Jace
 
My kingdom for a good timer!
My kingdom for a good timer!
 
Call JavaBean methods from JSP
Call JavaBean methods from JSP 2.0 pages
 
Into the mist of serializaton myths
Into the mist of serializaton myths
 
Interesting concept ...
Interesting concept ...
 
Excelling in Excel with Java
Excelling in Excel with Java
 
Koalog Configurator v1.0
What is Koalog ConfiguratorTM? Koalog ConfiguratorTM is a configurator written in JavaTM. It comes with two graphical user interfaces (a Swing and web one), an XML importer and a maintenance application. With Koalog ConfiguratorTM, users can rapidly
 
They just work
Writing CSV files: CSVPrinter This class makes it easy to output CSV. Given values, it will automatically determine if they need to be quoted and escape special characters. Comments can easily be written and correct line beginnings will be added.
 
Jeff Schmitt's JDBC Page
This tutorial assumes you are using the MySQL database and the GWE JDBC drivers. The host computer is triton.towson.edu.
 
JavaServer Pages Technology - Documentation
Sun's tutorial for Java Server Pages that provide a good introduction to design web pages with JSP.
 
Manage Database Metadata with POI and Excel
Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
 
BioInformatics Tools
BioInformatics Tools BioInformatics Tools The Bioinformatics tools are the software programs for the saving, retrieving and analysis of Biological data and extracting the information from them. Factors that must be taken into consideration when
 
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us.
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us. SuSe 9.1 Personal Linux Now Available SuSe 9.1 Personal CD's SuSE 9.1 Personal Edition was based on the x86 port of the Personal Edition, and it includes all of
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.