On 2002-09-11 17:15, Jegacats wrote:
What is the data column for?
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
F | G | H | I | J | K | L | |||
25 | Ordersheet | ||||||||
26 | lookuptable | Iteme | Qty | U-Price | Total | ||||
27 | $- | $5.99 | Item1010 | 1 | $1.00 | $1.00 | |||
28 | $15.00 | $6.25 | Item1020 | 3 | $5.50 | $16.50 | |||
29 | $25.00 | $6.55 | Item5010 | 2 | $6.59 | $13.18 | |||
30 | $30.00 | $7.50 | Item3020 | 1 | $20.50 | $20.50 | |||
31 | $40.00 | $8.00 | |||||||
32 | $50.00 | $10.00 | Subtotal | $51.18 | |||||
33 | $60.00 | $12.00 | ShippingandHandeling | $6.25 | |||||
34 | $70.00 | $14.00 | |||||||
35 | $80.00 | $16.00 | TotalOrdercost | $57.43 | |||||
36 | Tax-fromtable | Loc1 | $3.45 | ||||||
37 | |||||||||
38 | lookuptablefortax | Totalorder | $60.88 | ||||||
39 | Loc1 | 6% | |||||||
40 | Loc2 | 7% | |||||||
41 | Loc3 | 4% | |||||||
42 | Loc4 | 9% | |||||||
43 | Loc5 | 4% | |||||||
Sheet1 |
S_H_and_tax_ calcul.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | lookuptablefor S&H | Suggested USRETAIL | Client's S&H | Prov SalesTax8% | ||||
2 | $- | $5.99 | $18.95 | #N/A | ||||
3 | $15.00 | $6.25 | $21.95 | |||||
4 | $25.00 | $6.55 | $21.95 | |||||
5 | $30.00 | $7.50 | $159.95 | |||||
6 | $40.00 | $8.00 | $16.95 | |||||
7 | $50.00 | $10.00 | $9.95 | |||||
8 | $60.00 | $12.00 | $10.95 | |||||
9 | $70.00 | $14.00 | $7.95 | |||||
10 | $80.00 | $16.00 | $10.95 | |||||
11 | $9.95 | |||||||
12 | $1.00 | |||||||
13 | lookuptablefortax | $19.95 | ||||||
14 | Prov | 8% | $19.95 | |||||
15 | Fed | 7% | $19.95 | |||||
16 | Loc3 | 4% | $19.95 | |||||
17 | Loc4 | 9% | $99.95 | |||||
18 | Loc5 | 4% | $7.95 | |||||
Sheet1 |