A

B

D

E

F

G

H

J

L

$1$

$2.$ Home Product Line manager is running a promotion where price discounts vary by order size.

For orders under $$500,$ there is no price discount, for orders $$500-$$$1000$ the discount is $2\%,$ and so on as shown in the table.

Compute invoice reductions using VLOOKUP function. Compute also the adjusted final price.

HOME Product Line Orders

$\backslash$table$[[$Order #$,$Item Price,No$.$Items,Subtotal,$\backslash$table$[[$Discount Rate$]],$Final Price,,e Range,Discount Rate$],[12492,99\mathrm{.}95,7,699\mathrm{.}65,,,$$$,-,0\%$