You decided to initiate a marketing strategy of Save the Tax.If a client spends more than $500 on their order, they do not pay any tax.However, if the client does not spend more than $500, then they have to pay tax.

Using the tax rate in cell F10, insert a function to calculate the Tax Amount based on this marketing strategy

M21 X V fx A B C D F F 8 Bill To: G H 9 10 Tax Amount 15% 11 12 Phone: 13 Email: 14 15 Quantity Product# Product Name Description Unit Price Amount 16 21 11 Dunks Bits Dough to make the Bits $10.00 17 21 12 coffee Coffee powder to drink $5.00 18 21 13 suger Suger to put in drinks $3.00 Invoice Subtotal 19 Tax Amount 20 If you have any questions concerning this invoice, please contact me at the email above. Shipping Fee 21 Thank you for your business! Invoice Total 22 Monthly Payment 23 24 Invoice Template Inventory Customer List + EER Ready 26C 60924 O 9 * W Type here to search