Spreadsheet: 868096d1714812491-adding-an-extra-if-to-a-formular-stock-calculator-formular-creating-vlookup-0912
Sheet: Sheet1 (2)

 |  |  |  |  |  |  | Sales |  | Purchase
Code & Description |  | Unit | Barcode | Balance | Unposted | On Hand | Orders | Available | Orders |  | Supplier |  |  |  |  | Min Qty | Actual Status |  |  |  | [NAME] | Min Order Calc
Inventory Category : 001 - Aluminuim Foil Containers
100F |  | 2500 | T18-1114 | 4 | -1 | 3 | 0 | 3 | 0
104F |  | 1000 | B0202001 | 2 | 0 | 2 | 0 | 2 | 16
1236 |  | 10k | T0602001 | 12 | 0 | 12 | 0 | 12 | 0
2014 |  | 1500 | T0802001 | 13 | 0 | 13 | 0 | 13 | 0
2038 |  | 1000 | T18-1114 | 3.99999999999995 | 0 | 3.99999999999995 | 0 | 3.99999999999995 | 0
2050-02 |  | 900 | M08-1001 | 13 | 0 | 13 | 0 | 13 | 0
2074 |  | 600 | T17-1114 | 1 | 0 | 1 | 0 | 1 | 0
2233 |  | 1000 | B0106001 | 1.00000000000001 | 0 | 1.00000000000001 | 0 | 1.00000000000001 | 16
2258PLPF |  | 500 | M0108001 | 0 | 0 | 0 | 0 | 0 | 24
2282 |  | 500 | M0601001 | 4 | 0 | 4 | 0 | 4 | 0
2364 |  | 300 | M0502001 | 11 | 0 | 11 | 0 | 11 | 0
2427PL |  | 2500 | T1801114 | 2 | 0 | 2 | 0 | 2 | 0
2454 |  | 2200 | B0509001 | 15.0000000000002 | 0 | 15.0000000000002 | 0 | 15.0000000000002 | 0
2463 |  | 1000 | B0309001 | 21 | 0 | 21 | 0 | 21 | 0
2463PLPF |  | 1000 | B0411001 | 41 | 0 | 41 | 0 | 41 | 0
2472 |  | 1000 | M0401002 | 16 | 0 | 16 | 0 | 16 | 0
2618 |  | 2300 | M0204001 | 24 | 0 | 24 | 0 | 24 | 0
2650 |  | 1200 | T18-1114 | 3.00000000000001 | 0 | 3.00000000000001 | 0 | 3.00000000000001 | 0
2662 |  | 700 | T18-1114 | 3 | 0 | 3 | 0 | 3 | 0
2820 |  | 250 | B2002001 | 11 | 0 | 11 | 0 | 11 | 0
2824 |  | 200 | B1909001 | 39 | -4 | 35 | 0 | 35 | 0
3050 |  | 2000 | B1805001 | 1 | 0 | 1 | 0 | 1 | 25
3208 |  | 1000 | B1712999 | 35 | 0 | 35 | 0 | 35 | 0
3234 |  | 1000 | B2403001 | 6.00000000000004 | 0 | 6.00000000000004 | 0 | 6.00000000000004 | 0
3242 |  | 500 | B1614999 | 11 | 0 | 11 | 0 | 11 | 0
3260 |  | 430 | M1504001 | 12 | 0 | 12 | 0 | 12 | 0
3262 |  | 400 | T09-1999 | 5 | 0 | 5 | 0 | 5 | 0
3269 |  | 150 | B2316001 | 5 | -4 | 1 | 0 | 1 | 30
3278 |  | 125 | T2203001 | 44 | 0 | 44 | 0 | 44 | 0
3282 |  | 500 | B1216001 | 3 | 0 | 3 | 0 | 3 | 0
3286 |  | 560 | B1312002 | 7.99999999999999 | 0 | 7.99999999999999 | 0 | 7.99999999999999 | 0
35.87 |  | 250 | B2206001 | 2 | 0 | 2 | 0 | 2 | 28
365 |  | 480 | B1112001 | 25 | 0 | 25 | 0 | 25 | 0
365LID |  | 900 | T1701114 | 4 | 0 | 4 | 0 | 4 | 0
40C |  | 3800 | T0408001 | 26.9999999999999 | 0 | 26.9999999999999 | 0 | 26.9999999999999 | 0
511934-100 |  | 120 | M0702001 | -8.88178419700125e-15 | 0 | -8.88178419700125e-15 | 0 | -8.88178419700125e-15 | 24
543RPL |  | 400 | T0703114 | 5.99999999999999 | 0 | 5.99999999999999 | 0 | 5.99999999999999 | 0
830420-108 |  | 1000 | [NAME] | 20 | 0 | 20 | 0 | 20 | 0
830570-105 |  | 500 | T1801999 | 6 | 0 | 6 | 0 | 6 | 0
830860-501 |  | 900 | B2104001 | 23 | 0 | 23 | 0 | 23 | 0
850820-100 |  | 800 | B1404002 | 5 | 0 | 5 | 0 | 5 | 0
F63 |  | 4500 | T09-1999 | 7 | 0 | 7 | 0 | 7 | 0
P73 |  | 2000 | M1804001 | 25.0000000000001 | 0 | 25.0000000000001 | 0 | 25.0000000000001 | 0
WN-057 |  | 2000 | B0606001 | 0.999999999999901 | 0 | 0.999999999999901 | 0 | 0.999999999999901 | 20