Exercise 3 - Discount
Use the blank table below-right to create a VLOOKUP table to determine the discount percent as follows:
$0 to $100 inclusive receive a 2% discount
$100.01 to $200 inclusive receive a 5% discount
$200.01 to $300 inclusive receive a 7% discount
$300.01 inclusive and over receive a 10% discount
Invoice #	Invoice Amount	Discount$		Table
18932	$ 343.71			Enter Label	Enter Label
18935	$ 98.37
18938	$ 197.68
18941	$ 353.05
18944	$ 279.73
18947	$ 42.39
18950	$ 16.79
18953	$ 113.88
18956	$ 107.31
18959	$ 185.47
18962	$ 364.81
18965	$ 22.36
18968	$ 217.31