Day 14 - Using IF Function in Business
Case | Wizard Works
Andrew Howe owns and operates Wizard Works, an online seller of fire-works based in Franklin, Tennessee. Andrew wants you to help him use Excel to develop an order form for his business. The form needs to contain formulas to calculate the charge for each order. The total charge is based on the quantity and type of items ordered plus the shipping charge and the 5% sales tax. Orders can be shipped using standard 3 to 5 day shipping for $4.99 or overnight for $12.99. Andrew is also offering a 3% discount for orders that exceed $200.00. Both the shipping option and the discount need to be calculated using formulas based on values entered into the worksheet.
Data File Required
The file on the left side is an instruction file. Click on Download File to open the file. Once opened, print a copy to get started. This particular assignment requires a data file to start. After printing the instruction file, go to the Data Files tab and open "Wizard" workbook to start.
If you're working in the classroom, you may find the Data File in the Share drive.