Using the IF Function
Duration: 15 to 25 minutes.
In this exercise, you will practice using the IF function.
 Open Functions.xlsx from your Excel2013.2/Exercises folder and go to the sheet named "IF".
 Use the IF function to enter "Yes" or "No" in column E based on whether revenue from each customer exceeded $10,000 (i.e., if revenue exceeded $10,000, enter "Yes"; otherwise, enter "No").
 Use the IF function to enter "Yes" or "No" in column F based on whether the number of purchases from each customer was greater than or equal to 20 (i.e., if # of purchases exceeded 19, enter "Yes"; otherwise, enter "No".)
 Use the IF function to enter the revenue received from customers located in Utica, and only Utica, in column G (i.e., if the customer is located in Utica, enter revenue; otherwise, leave blank).
 Use the IF function to enter "Yes" or "No" in column E based on whether revenue from each customer exceeded $10,000.
 The information you need to enter this formula is:
 Logical Test: If revenue is greater than $10,000, then...
 Value if True: "Yes"
 Value if False: "No"
 The formula is: =IF(B2>10000,"Yes","No")
 Enter the formula using the Insert Function command:
 Select cell E2.
 On the FORMULAS tab, in the Function Library group, click the Insert Function command:
 In the Insert Function dialog box:
 Search on "IF" or, in the Or select a category dropdown box, select Logical.
 Under Select a function, select IF.
 Click OK.
 In the Function Arguments dialog box, enter the following values and click OK:

Logical_test: B2>10000

Value_if_true: "Yes"

Value_if_false: "No"
 Copy the formula from cell E2 to cells E3:E8.
 Use the IF function to enter "Yes" or "No" in column F based on whether the number of purchases from each customer was greater than or equal to 20.
 The information you need to enter this formula is:
 Logical Test: If the number of purchases is greater than 19, then...
 Value if True: "Yes"
 Value if False: "No"
 The formula is: =IF(C2>19,"Yes","No")
 Enter the formula using the Insert Function command:
 Select cell F2.
 On the FORMULAS tab, in the Function Library group, click the Insert Function command:
 In the Insert Function dialog box:
 Search on "IF" or, in the Or select a category dropdown box, select Logical.
 Under Select a function, select IF.
 Click OK.
 In the Function Arguments dialog box, enter the following values and click OK:

Logical_test: C2>19

Value_if_true: "Yes"

Value_if_false: "No"
 Copy the formula from cell F2 to cells F3:F8.
 Use the IF function to enter the revenue received from customers located in Utica, and only Utica, in column G.
 The information you need to enter this formula is:
 Logical Test: If city is Utica, then...
 Value if True: Revenue (B2)
 Value if False: None ("")
 The formula is: =IF(D2="Utica",B2,"")
 Enter the formula using the Insert Function command:
 Select cell G2.
 On the FORMULAS tab, in the Function Library group, click the Insert Function command:
 In the Insert Function dialog box:
 Search on "IF" or, in the Or select a category dropdown box, select Logical.
 Under Select a function, select IF.
 Click OK.
 In the Function Arguments dialog box, enter the following values and click OK:

Logical_test: D2="Utica"

Value_if_true: B2

Value_if_false: ""
 Copy the formula from cell G2 to cells G3:G8.