Download
| Description | Size | Download |
|---|---|---|
The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them. How to use:
| 649 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
This template is based on the c4030. It adds a bamboo Chinese painting image as the background.
This form layout includes a column of "Taxable" checkboxes that are placed in column B, i.e., outside the printable section. The checkboxes are form controls that are named "oknWidget_taxable1, oknWidget_taxable2, oknWidget_taxable3,...". Each tax box is linked to a hidden cell.
We then use an Excel array formula to calculate the taxable subtotal:
{=SUM ( oknTaxable_1:oknTaxable_6 * oknLineTotal_1:oknLineTotal_6 )}And then the tax is calculated using a formula like this:
=ROUND ( IF ( oknTaxType=0,0, oknTax1Rate * ( oknLineTotalTaxable + IF ( oknTaxTotalIncludingShippingCost = 0, 0 , oknShippingCost))), 2 )
If all your items are taxable (or not taxable), you can safely delete all the "Taxable" checkbox controls and then modify the tax formula to simplify the tax calculation:
=ROUND ( IF ( oknTaxType=0,0, oknTax1Rate * ( oknSubtotal + IF ( oknTaxTotalIncludingShippingCost = 0, 0 , oknShippingCost))), 2 )
Format and Specification
| Template# | c4096 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 4 |
| Lines | 6 |
| Line Height (Points) | 49.50 |
| Print Area | $F$3:$P$41 |
| Papaer Orientation | Portrait |
| Default Margins (Points) | |
| Left | 16.56 |
| Right | 36.00 |
| Top | 72.00 |
| Bottom | 72.00 |
| Price | Free |
