Home
MS Office - How to ?
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Free e-books
VIDEO Tutorials
Office 2007 Guides
Excel 2007 Tutorials
PowerPoint 2007 Guides
Word 2007 Tutorials
MS Office Template
Free Clip Art
Keyboard Shortcut
Tips and Tricks
MS Outlook
MS Publisher
Free Newsletter
MS Windows
Contact Us
Site Map
Google Docs and ...
You and This Site
Resources Page

XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google
 


Discover the Full Potential of
Excel IF Function


The Excel IF Function checks a condition that must be either true or false. If the condition is true, the function returns one value; if the condition is false, the function returns another value.

The function has three arguments: the condition you want to check, the value to return if the condition is true, and the value to return if the condition is false.

Here is the Excel IF()Syntax:
IF(Logical_test, Ation_if_true, Action_if_false)

Logical _test
The logical_test evaluates an expression to see if it passes the test, i.e. is TRUE or does not pass the test, i.e. is FALSE.

Logical operators

Excel Logical Operators



Action_if_true
Action_if_true can be a value or an operation. Whichever, the result is placed in the cell that contains the IF ( ) Function if the logical_test is true.

Action_if_false
Action_if_false can be a value or an operation. Whichever, the result is placed in the cell that contains the IF ( ) Function if the logical_test is false.

To demonstrate the Excel IF function

Lets look at an example for calculating a bonuses based on total sales. A company offers its salesman a 5% bonus if the value of the total sales is below $5,000 per month. If the total sales exceed $5,000 per month, the bonus will be 10%.

When translated into the IF ( ) function it looks like the following:
IF(TotalSales>5000,TotalSales * 10%, TotalSales * 5%)

  • Enter the following data for column A and column B accordingly.

    Excel data



  • Click on the cell to contain the IF( ) function. In this case, cells C2.
  • From the Insert menu, click on Function…to display the Insert Function dialog box.
    OR press the Shift+F3

    Insert Function dialog box



  • From the Insert Function dialog box displayed, select the IF option and then click OK button. The following dialog box will be displayed.



  • Enter B2 > 5000 into the Logical_test text area. Press the Tab key.
  • Enter 10% into the Value_if_true text area. Press the Tab key.
  • Enter 5% into the Value_if_false text area. Click OK.
  • Follow the same procedure for the cells C3 to C6.

    Note: Every time, you just need to change the data from B2 to B6, then the bonus will be automatically calculated.

    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


    Recommended book:

    Revealed! 101 Excel Secrets Revealed! 101 Excel Secrets


    >> Next Topic : Using the Excel CHOOSE( ) Function
    << Previous Topic : How to Install, Remove and Get Free Excel Add-in?


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


    footer for excel If function page

    		•