Apply the IF Statement to the example files

ASSIGNMENT

Without going back through each of the example videos, fill out each of the attached excel file examples. Take your time and think through what was taught in the videos. If you're stuck, go back through and watch the video examples. Once you believe you have a good grasp on the topic, follow the below deliverable steps:

DELIVERABLE

Now that you understand how each of the examples are filled out, its time to put your own spin on the project:

Redo the "Example 1" file by changing the age of an "adult" to 16
Redo the "Example 2" file by changing the rebate threshold from $100 to $50
Redo the "Example 3" file by changing the discount tiers from $100,$50,$25 to $200,$100,$50
Redo the "Example 4" file by changing the rebate threshold from $100 to $50 and giving the rebate to non-contract customers (customers with a "No" in the contract column)

Skillshare doesn't let you upload Excel files so upload a screenshot of your Excel file.

RESOURCES

IF Statement Examples.xlsx

Wilde Bali

--

1