Spreadsheet: 45144d1243924297-if-statement-simplification-inv
Sheet: Inventory

 |  |  | CATEGORY |  | PRODUCT |  | PACKAGE TYPE |  | SHIPPING COST |  | NET COST | EBAY FEES |  | ADDON FEES | PAYPAL FEES | TOTAL COST |  |  | LISTING PRICE |  | LISTING S&H |  | LOWEST TOTAL PRICE | TOTAL INFLOW |  | PROFIT | ACTIVE
 |  |  | OTHER |  | 1 Pack Topsy Turvy |  |  |  |  |  |  | #N/A |  |  | 3.2 | #N/A |  |  | 100 |  |  |  | 12.49 | 100 |  | #N/A | #N/A
 |  |  | ELCTR |  | 2 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 22.5 | 0 |  | 0 | N
 |  |  | COMP |  | 3 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 32.99 | 0 |  | 0 | N
 |  |  | CLOTH |  | 4 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 36.99 | 0 |  | 0 | N
 |  |  | MEDIA |  | 5 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 44.99 | 0 |  | 0 | N
 |  |  | OTHER |  | 6 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 49.99 | 0 |  | 0 | N
 |  |  |  |  | 8 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 75 | 0 |  | 0 | N
 |  |  |  |  | 10 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  | 12 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 139.99 | 0 |  | 0 | N
 |  |  |  |  | 24 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 239.98 | 0 |  | 0 | N
 |  |  |  |  | 48 Pack Topsy Turvy |  |  |  |  |  | 241.68 |  |  |  |  | 241.68 |  |  |  |  |  |  |  | 0 |  | -241.68 | Y
 |  |  |  |  | [NAME] |  |  |  |  |  | 3.5 |  |  |  |  | 3.5 |  |  |  |  |  |  | 12 | 0 |  | -3.5 | Y
 |  |  |  |  | Snuggie |  |  |  |  |  | 7.01 |  |  |  |  | 7.01 |  |  |  |  |  |  | 17.25 | 0 |  | -7.01 | Y
 |  |  |  |  | 10 2" Net Pots |  |  |  |  |  | 3.95 |  |  |  |  | 3.95 |  |  |  |  |  |  | 5.24 | 0 |  | -3.95 | Y
 |  |  |  |  | 10 3" Net Pots |  |  |  |  |  | 5.9 |  |  |  |  | 5.9 |  |  |  |  |  |  | 7.8 | 0 |  | -5.9 | Y
 |  |  |  |  | 1 [NAME] |  | FRS |  | 4.95 |  | 0.75 |  |  |  |  | 5.7 |  |  |  |  |  |  | 8.19 | 0 |  | -5.7 | Y
 |  |  |  |  | 10 3.75" Net Pots |  |  |  |  |  | 5.99 |  |  |  |  | 5.99 |  |  |  |  |  |  | 8.48 | 0 |  | -5.99 | Y
 |  |  |  |  | 10 5" Net Pots |  |  |  |  |  | 9.95 |  |  |  |  | 9.95 |  |  |  |  |  |  | 12.45 | 0 |  | -9.95 | Y
 |  |  |  |  | 2 [NAME] |  | FR2 |  | 10.35 |  | 1.51 |  |  |  |  | 11.86 |  |  |  |  |  |  | 13.88 | 0 |  | -11.86 | Y
 |  |  |  |  | 6" Net Cup |  |  |  |  |  | 10.95 |  |  |  |  | 10.95 |  |  |  |  |  |  | 14.99 | 0 |  | -10.95 | Y
 |  |  |  |  | 20 3" Net Pots |  |  |  |  |  | 11.9 |  |  |  |  | 11.9 |  |  |  |  |  |  | 15.88 | 0 |  | -11.9 | Y
 |  |  |  |  | 168 GPH Sump Pump |  |  |  |  |  | 13.95 |  |  |  |  | 13.95 |  |  |  |  |  |  | 17.99 | 0 |  | -13.95 | Y
 |  |  | OTHER |  | Hydrofarm 15 Amp 24 Hour Grounded Timer |  |  |  |  |  | 15.95 |  |  |  |  | 15.95 |  |  |  |  |  |  | 19.99 | 0 |  | -15.95 | Y
 |  |  | OTHER |  | Hydrofarm 7-Day Grounded Digital Timer |  |  |  |  |  | 19.95 |  |  |  |  | 19.95 |  |  |  |  |  |  | 30.4 | 0 |  | -19.95 | Y
 |  |  | OTHER |  | Hydrofarm 7 Day Dual Outlet Digital Timer |  |  |  |  |  | 19.95 |  |  |  |  | 19.95 |  |  |  |  |  |  | 31.33 | 0 |  | -19.95 | Y
 |  |  |  |  | Active Air 6" In-Line Booster Fan |  |  |  |  |  | 54.95 |  |  |  |  | 54.95 |  |  |  |  |  |  | 73.1 | 0 |  | -54.95 | Y
 |  |  |  |  | Active Air 8" In-Line Booster Fan |  |  |  |  |  | 72.95 |  |  |  |  | 72.95 |  |  |  |  |  |  | 83.1 | 0 |  | -72.95 | Y
 |  |  |  |  | Active Air 10" In-Line Booster Fan |  |  |  |  |  | 94.95 |  |  |  |  | 94.95 |  |  |  |  |  |  | 93.1 | 0 |  | -94.95 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | N