PROBLEM 6

Step 2

In Cells D7 - D13, enter a formula using the IF logical function to place the amount in Cells B7 - B13 in cells D7 - D13 if the amount in Cells B7 - B13 is Over $80,000. (If the amount in cells B7 - B13 is greater than $80,000, then the amount should be placed in cells D7 - D13)