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:
| 983 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
This form includes two editable columns, Description and Amount, and a Taxable checkbox column.
It includes the "Ship To" section, which contains 5 fields, namely oknShipName, oknShipAddress, oknShipCityStateZip, oknShipCountry, and oknShipContact.
The formulas are set so that when a Taxable box is checked, the Amount of the current line is included when calculating taxes. This is done by using an array formula for a hidden cell named oknLineTotalTaxable:
{=SUM(oknTaxable_1:oknTaxable_6*oknLineTotal_1:oknLineTotal_6)}Note the "{" and "}" symbols in the formula, which indicate it is an array formula.
Format and Specification
| Template# | c2025 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 2 |
| Lines | 6 |
| Line Height (Points) | 39.75 |
| Print Area | $D$3:$M$41 |
| Papaer Orientation | Portrait |
| Default Margins (Points) | |
| Left | 16.56 |
| Right | 36.00 |
| Top | 72.00 |
| Bottom | 72.00 |
| Price | Free |
