Your task: Use the $$IF$$ formula to populate the Column beginning at F$7$ with the proper discount level listed in the discount table for all your customers. If you have done this properly, the only place you should have to change the discount percentage is in Cell F$3$ or F$4$ and your formulas should automatically change the discount level for each customer affected.

In order to do this, you will need to learn how the IF formula works and you will need to know the difference between relative and absolute cell references. We have covered these in class and you can also use the help function in Excel and by searching the web.