Instructor Explanation: The IF function will evaluate to determine if a specified condition is true or false. The function will return a value if the specified condition is true, or a different value if the specified condition is false. The values can be text, or calculations. In this step, you will determine the sale price according to the sale date. If the sale occurs before 1/10/2020, there is a 15% discount. If the sale occurs after 1/10/2020, the regular price is charged. This is a powerful function you will want to master and will soon discover the variety of opportunities it provides. If editing is necessary for any function, click the cell containing the function, then click the Insert Function Button. You will be back in the Function Arguments dialogue box. Here's How: 0OOO Click to select cell G6 Click the Insert Function Button to the left of the Formula Bar fc Search if necessary and select IF Click OK (a double-click on the function will also work as OK) (MAC users click Insert Function) In the Function Arguments dialogue box, click inside the Logical_test space Type: sale_date