"Excel 2007 IF Function: A Real-Live Example Demonstration"

The Excel 2007 IF function, one of Excel's logical functions, tests to see if a certain condition in a spreadsheet is true or false.

You can use the IF Function for various purposes. For example, you can use the function to grade student exam scores. If the student has above 85, award an A grade; if the student has below 40, award a fail grade.

The syntax for the IF function is:

=IF (logical_test, value_if_true, value_if_false)

logical_test - a value or expression that is tested to see if it is true or false.
value_if_true - the value that is displayed if logical_test is true.
value_if_false - the value that is displayed if logical_test is false.

To use the Excel 2007 IF function (an example)

• Enter the following data in an Excel worksheet as illustrated.

• Let say the student scores are based on the following:
A If the student scores 85 or above
B If the student scores 70 to 84
C If the student scores 55 to 69
D If the student scores 40 to 54
FAIL If the student scores below 40

• Now, click on cell C3 - the location where one of the results will be displayed.
• Click on the Formulas tab and choose Logical function from the ribbon to open the drop down list.
• Click on IF in the list to bring up the function's dialog box.

• From the If Function Arguments dialog box displayed, click on the icon with red color pointing upwards behind the Logical_test.

• Then, type in the following formula and click on the red color icon pointing down.
B3>=85, "A", IF(B3>=70, "B", IF(B3>=55, "C", IF(B3>=40, "D", "Fail" ) ) )
• Click OK.
• If you want to see the full formula, click on the cell C3 and the formula will be display on the Formula Bar.

Note: Some of the conditional operator you need to know:
< - Less Than
>= - Greater than Or Equal To
<= - Less than Or Equal To
<> - Not Equal To

Related Topics:

This tutorial is about Excel 2007 IF function, more Excel 2007 tutorials can be found at the following links:

How to Write a Formula in Microsoft Excel 2007?
Knowing the Different Types of Excel 2007 Functions
How to Use the Cell Function in Microsoft Excel 2007?
Guide to Use the NOW Function Correctly in Excel 2007
Demonstration of Using the Date and Time Functions with Excel 2007
Use the Microsoft Excel 2007 Product Function to Perform the Calculation
Use the Excel 2007 MAX Function to Find a Largest Number in a Series
Using the Excel 2007 Count Function - Example Demonstration
Guide to Use the Excel 2007 Radian Function Correctly

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

Custom Search

Back to Top

You're viewing the Excel 2007 IF function info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb