Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: MS Excel Functions IF Function Tutorial

The IF function will check the logical condition of a statement and return one value if true and a different value if false.

Tutorial Details:

IF Function in excel

The next function we will discuss is IF . The IF function will check the logical condition of a statement and return one value if true and a different value if false.
The syntax is
=IF (condition, value-if-true, value-if-false) value returned may be either a number or text. If value returned is text, it must be in quotes.

Lets use the table here for the discussion that follows. We will look at several different specific examples that show how the IF functions can be used!

Example of IF
typed into column B
Compares
Answer
=IF (A2>1,"Yes","No")
is ( .95 > 1)
No
=IF (A3>1, "Yes", "No")
is (1.37 > 1)
Yes


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
MS Excel Functions IF Function Tutorial

View Tutorial:
MS Excel Functions IF 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
 
Bean Markup Language, Part 1 - JavaWorld August 1999
Bean Markup Language, Part 1 - JavaWorld August 1999
 
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
 
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
 
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
 
Interesting concept ...
Interesting concept ...
 
Excelling in Excel with Java
Excelling in Excel with Java
 
Lisp and Java
Lisp and Java In this article, we\'re going to steal an idea from one of the most theft-worthy languages out there: Lisp. We\'re going to pick out one of its most useful features -- the ability to treat functions as data -- and talk about how to apply th
 
OpenSign
OpenSign OpenSign is a java applet for signing text in a webbrowser using a PKCS-12 key-files or keys located in MS Crypto API CSP's in a Win32 environment. The applet is based on code kindly provided by IT-Practice and everyone is encouraged to subm
 
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.
 
JavaRSS.com 2004: Review of the Year
A look back at the major events of 2004 in Java.
 
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.