Certainly! Below is an updated version of the billing information worksheet that includes Sale Amount (SA), Discount Amount (DA), and Amount to be Paid (FP) based on the provided formulae:
```plaintext
--------------------------------------------------------------------------------
| Invoice No | Date | Customer Name | Product | Sale Amount | Discount | Discount Amount | Amount to be Paid |
--------------------------------------------------------------------------------
| 1001 | 2023-01-15 | John Doe | Product A | $50.00 | 10% | $5.00 | $45.00 |
| 1002 | 2023-01-20 | Jane Smith | Product B | $75.00 | 15% | $11.25 | $63.75 |
| 1003 | 2023-02-05 | Mark Johnson | Product C | $120.00 | 20% | $24.00 | $96.00 |
| 1004 | 2023-02-10 | Emily Davis | Product A | $50.00 | 10% | $5.00 | $45.00 |
--------------------------------------------------------------------------------
| Total Amount: $249.75 |
--------------------------------------------------------------------------------
```
To create this in a spreadsheet:
1Open Excel or Google Sheets.
2. Enter the headers:
- "Invoice No"
- "Date"
- "Customer Name"
- "Product"
- "Sale Amount"
- "Discount"
- "Discount Amount"
- "Amount to be Paid"
3. Enter the data in rows below the headers.
4. Use the appropriate date format for the "Date" column.
5 Format the "Sale Amount," "Discount Amount," and "Amount to be Paid" columns as currency.
6. Calculate the Discount Amount for each row using a formula like `=B2*(1-C2)` for the "Discount Amount" column (assuming your data starts from row 2).
7. Calculate the Amount to be Paid for each row using a formula like `=E2-D2` for the "Amount to be Paid" column (assuming your data starts from row 2).
8. Calculate the total amount to be paid using a formula like `=SUM(H2:H5)` (assuming your data starts from row 2 and ends at row 5).
9. Apply any additional formatting or styling as needed.
This updated table now includes columns for Discount Amount and Amount to be Paid based on the provided formulae. Adjust the formulas based on your specific spreadsheet software and requirements.
0 टिप्पणियाँ:
Post a Comment