1. Insert a formula for the Amount in the Sales. The formula should multiply the Price and Quantity.
2. Insert a formula for the Total Amount. It should compute for the sum of all sales.
3. The Final Amount is computed by: Total Amount + Tax - Discount. Insert a formula for this.
4. The Tax is computed by getting the 20% of the Total Amount. This needs to be displayed in A32.
5. The Discount is computed by getting the 5% of the Total Amount. This needs to be displayed in C32.
6. The Paid field refers to any amount given by the client. It can be less than the Total Amount. Credit is allowed.
7. The Due field is computed by subtracting Paid field from the Final Amount.

D E G H INVOICE 1 Your Clinic Name 2 3 4 Date & Time INVOICE NO Street Address City, Zip Code Phone # 5 6 Bill To: Product/Service Description Product 1 Service 1 Product 2 Product 3 Service 2 Price Quantity Amount 89.25 10 7,500.00 1 250.00 5 75.00 15 10,000.00 7 8 Name 9 Company Name 10 Street Address 11 City, Zip Code 12 Phone #: 13 Email Address: 14 15 SI No. 16 1 17 2 18 3 19 4 20 5 21 22 23 24 25 26 27 28 29 30 31 TAX 20% 32 33 34 Received By: 35 Noted By: Discount 5% Total Amount Final Amount Paid Due