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


    >> 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