Spreadsheet: 45327d1244089699-if-statement-simplification-ebay1
Sheet: LISTINGS

 |  |  |  |  | 5
 |  |  | PRODUCT | SIZE |  | QTY | UNIT | PACKAGE | SHIPPING | NET | EBAY FEES | PAYPAL FEES | TOTAL COST |  | MSRP | LISTING PRICE | LISTING S&H | TOTAL INFLOW | PROFIT
 |  |  | Hydroton |  |  | 1 | LB | FRS | 4.95 | 0.75492 | 0.7088 | 0.53026 | 6.943980000000001 |  |  | 2.99 | 4.95 | 7.94 | 0.9960199999999997
 |  |  | Hydroton |  |  | 2 | LB | FR2 | 10.35 | 1.50984 | 0.8288 | 0.7158599999999999 | 13.4045 |  |  | 3.99 | 10.35 | 14.34 | 0.9355000000000011
 |  |  | Hydroton |  |  | 3 | LB | FR2 | 10.35 | 2.26476 | 0.9488 | 0.7448600000000001 | 14.30842 |  |  | 4.99 | 10.35 | 15.34 | 1.031579999999998
 |  |  | Hydroton |  |  | 5 | LB | FR2 | 10.35 | 3.7746 | 1.0688 | 0.77386 | 15.96726 |  |  | 5.99 | 10.35 | 16.34 | 0.3727400000000003
 |  |  | Hydroton |  |  | 7 | LB | FR2 | 10.35 | 5.28444 | 1.3088 | 0.83186 | 17.7751 |  |  | 7.99 | 10.35 | 18.34 | 0.5649000000000015
 |  |  | Hydroton |  |  | 9 | LB | FR2 | 10.35 | 6.794280000000001 | 1.5488 | 0.8898600000000001 | 19.58294 |  |  | 9.99 | 10.35 | 20.34 | 0.7570599999999992
 |  |  | Hydroton |  |  | 13 | LB | FRL | 13.95 | 11.05 | 2.1488 | 1.13926 | 28.28806 |  |  | 14.99 | 13.95 | 28.94 | 0.6519399999999962
 |  |  | Net Pot | 3" |  | 10 | EA | - | 0 | 5.95 | 0.47 | 0.51721 | 6.93721 |  | 7.65 | 1 | 6.49 | 7.49 | 0.5527899999999999 |  |  | <
 |  |  | Net Pot | 3" |  | 30 | EA | - | 0 | 17.85 | 1.0688 | 0.90842 | 19.82722 |  |  | 5.99 | 14.99 | 20.98 | 1.15278 |  |  | <
 |  |  | Net Pot | 3.75" |  | 20 | EA | - | 0 | 13.9 | 0.9488 | 0.79242 | 15.64122 |  |  | 4.99 | 11.99 | 16.98 | 1.33878 |  |  | <
 |  |  | Net Pot | 3.75" |  | 30 | EA | - | 0 | 20.85 | 1.9088 | 1.05342 | 23.81222 |  |  | 12.99 | 12.99 | 25.98 | 2.16778
 |  |  | Net Pot | 3.75" |  | 40 | EA | - | 0 | 27.8 | 2.7488 | 1.31442 | 31.86322 |  |  | 19.99 | 14.99 | 34.98 | 3.116779999999999
 |  |  | Net Pot | 3.75" |  | 50 | EA | - | 0 | 34.75 | 3.5888 | 1.54642 | 39.88522 |  |  | 26.99 | 15.99 | 42.98 | 3.09478
 |  |  | Net Pot | 5" |  | 5 | EA | - | 0 | 4.25 | 0.5888 | 0.61842 | 5.45722 |  | 9.25 | 1.99 | 8.99 | 10.98 | 5.522780000000001 |  |  | <
 |  |  | Net Pot | 5" |  | 10 | EA | - | 0 | 9.95 | 0.7088 | 0.6619200000000001 | 11.32072 |  | 15.3 | 2.99 | 9.49 | 12.48 | 1.159280000000001 |  |  | <
 |  |  | Net Pot | 5" |  | 15 | EA | - | 0 | 12.75 | 0.9488 | 0.82142 | 14.52022 |  |  | 4.99 | 12.99 | 17.98 | 3.45978
 |  |  | Net Pot | 5" |  | 20 | EA | - | 0 | 19.9 | 1.7888 | 1.02442 | 22.71322 |  | 25.51 | 11.99 | 12.99 | 24.98 | 2.266780000000001
 |  |  | Net Pot | 5" |  | 25 | EA | - | 0 | 21.25 | 2.2688 | 1.08242 | 24.60122 |  | 27.88 | 15.99 | 10.99 | 26.98 | 2.378780000000003
 |  |  | Net Pot | 5" |  | 30 | EA | - | 0 | 29.85 | 2.1488 | 1.19842 | 33.19722 |  | 30.98 | 14.99 | 15.99 | 30.98 | -2.217220000000001
 |  |  | Net Pot | 5" |  | 40 | EA | - | 0 | 39.8 | 3.3488 | 1.57542 | 44.72422 |  |  | 24.99 | 18.99 | 43.98 | -0.7442199999999985
 |  |  | Net Pot | 5" |  | 50 | EA | - | 0 | 42.5 | 3.9488 | 1.63342 | 48.08222 |  | 44.95 | 29.99 | 15.99 | 45.98 | -2.102220000000003 |  | NO
 |  |  | Net Pot | 6" |  | 5 | EA | - | 0 | 5 | 0.7088 | 0.64742 | 6.35622 |  | 12.49 | 2.99 | 8.99 | 11.98 | 5.62378 |  |  | <
 |  |  | Net Pot | 6" |  | 10 | EA | - | 0 | 10.95 | 1.0688 | 0.79242 | 12.81122 |  | 17.1 | 5.99 | 10.99 | 16.98 | 4.168780000000002
 |  |  | Net Pot | 6" |  | 15 | EA | - | 0 | 15 | 1.3088 | 0.9664200000000001 | 17.27522 |  |  | 7.99 | 14.99 | 22.98 | 5.70478 |  |  | <
 |  |  | Net Pot | 6" |  | 20 | EA | - | 0 | 21.9 | 2.5088 | 1.25642 | 25.66522 |  | 33.88 | 17.99 | 14.99 | 32.98 | 7.314779999999999
 |  |  | Net Pot | 6" |  | 25 | EA | - | 0 | 25 | 2.9888 | 1.43042 | 29.41922 |  |  | 21.99 | 16.99 | 38.98 | 9.560779999999994
 |  |  | Net Pot | 6" |  | 30 | EA | - | 0 | 32.85 | 3.5888 | 1.57542 | 38.01422 |  |  | 26.99 | 16.99 | 43.98 | 5.965779999999995
 |  |  | Net Pot | 6" |  | 40 | EA | - | 0 | 43.8 | 4.6688 | 1.83642 | 50.30521999999999 |  |  | 35.99 | 16.99 | 52.98 | 2.674780000000013
 |  |  | Net Pot | 6" |  | 50 | EA | - | 0 | 54.75 | 5.2688 | 2.12642 | 62.14522 |  | 61.35 | 40.99 | 21.99 | 62.98 | 0.8347800000000021
 |  |  | Earth Nectar/Earth Ambrosia | 16 OZ |  | 1 | EA | - | 0 | 23.95 | 3.4688 | 1.16942 | 28.58822 |  |  | 25.99 | 3.99 | 29.98 | 1.391780000000001
 |  |  | Earth Nectar/Earth Ambrosia | 32 OZ |  | 1 | EA | - | 0 | 35.95 | 4.788799999999999 | 1.57542 | 42.31422000000001 |  |  | 36.99 | 6.99 | 43.98 | 1.665779999999998
 |  |  | Earth Nectar/Earth Ambrosia | 128 OZ |  | 1 | EA | - | 0 | 119.95 | 16.3088 | 4.446420000000001 | 140.70522 |  |  | 132.99 | 9.99 | 142.98 | 2.274780000000021
 |  |  | Activeair 2 Way Moisture/Ph Meter |  |  | 1 | EA | - | 0 | 9.95 | 1.1888 | 0.67642 | 11.81522 |  |  | 6.99 | 5.99 | 12.98 | 1.16478
 |  |  | Activeair 3 Way Meter |  |  | 1 | EA | - | 0 | 11.95 | 1.4288 | 0.7344200000000001 | 14.11322 |  |  | 8.99 | 5.99 | 14.98 | 0.8667800000000021
 |  |  | PRODUCT | SIZE |  | QTY | UNIT | PACKAGE | SHIPPING | NET | EBAY FEES | PAYPAL FEES | TOTAL COST |  | MSRP | LISTING PRICE | LISTING S&H | TOTAL INFLOW | PROFIT
 |  |  | Active Air In-Line Booster Fan | 6" |  | 1 | EA | - | 0 | 59.95 | 8.1488 | 2.38742 | 70.48622 |  |  | 64.99 | 6.99 | 71.97999999999999 | 1.493779999999987
 |  |  | Active Air In-Line Booster Fan | 8" |  | 1 | EA | - | 0 | 72.95 | 9.708799999999998 | 2.85142 | 85.51022 |  |  | 77.99 | 9.99 | 87.97999999999999 | 2.469779999999986
 |  |  | Active Air In-Line Booster Fan | 10" |  | 1 | EA | - | 0 | 94.95 | 12.3488 | 3.57642 | 110.87522 |  |  | 99.99 | 12.99 | 112.98 | 2.104779999999991
 |  |  | [NAME] |  |  | 1 | EA | - | 0 | 38 | 7.4288 | 2.01071 | 47.43951000000001 |  |  | 58.99 | 0 | 58.99 | 11.55049
 |  |  | [NAME] |  |  | 1 | EA | - | 0 | 59 | 9.8288 | 2.59071 | 71.41951 |  |  | 78.99 | 0 | 78.99 | 7.570489999999992
 |  |  | Viva Las Vegas 200 pc Elvis Poker Set |  |  | 1 | EA | - | 0 | 14.21 | 3.3488 | 1.02471 | 18.58351 |  | 49.95 | 24.99 | 0 | 24.99 | 6.406489999999998
 |  |  | 3D Pool Table |  |  | 1 | EA | - | 0 | 29.14 | 5.028799999999999 | 1.43071 | 35.59951 |  | 129.95 | 38.99 | 0 | 38.99 | 3.390490000000007
 |  |  | Butt / Face Soap |  |  | 1 | EA | - | 0 | 2.98 | 1.0688 | 0.47371 | 4.52251 |  | 5.95 | 5.99 | 0 | 5.99 | 1.467490000000001
 |  |  | Light Up Volleyball Net |  |  | 1 | EA | - | 0 | 55.76 | 8.7488 | 2.32971 | 66.83851 |  | 99.95 | 69.99 | 0 | 69.99 | 3.151489999999995
 |  |  | Weener Kleener [NAME] |  |  | 1 | EA | - | 0 | 4.42 | 0.9488 | 0.50242 | 5.87122 |  | 7.95 | 4.99 | 1.99 | 6.98 | 1.10878
 |  |  | South Park Deluxe Poker Set |  |  | 1 | EA | - | 0 | 15.2 | 1.6688 | 0.85042 | 17.71922 |  | 19.95 | 10.99 | 7.99 | 18.98 | 1.26078
 |  |  | R/C Motocross Stunt Bike |  |  | 1 | EA | - | 0 | 16.86 | 2.7488 | 0.9374199999999999 | 20.54622 |  | 69.95 | 19.99 | 1.99 | 21.98 | 1.433779999999999
 |  |  | Active Aqua PU250 | 250 GPH |  | 1 | EA | - | 0 | 18.95 | 1.5488 | 0.99542 | 21.49422 |  |  | 9.99 | 13.99 | 23.98 | 2.485780000000002
 |  |  | Topsy Turvy |  |  | 1 | EA | - | 0 | 14.9 | 0.47 | 0.70455 | 16.07455 |  | 13.99 | 1 | 12.95 | 13.95 | -2.124550000000003 |  | NO
 |  |  | Topsy Turvy |  |  | 2 | EA | - | 0 | 24.85 | 0.9488 | 1.02442 | 26.82322 |  | 26.89 | 4.99 | 19.99 | 24.98 | -1.843220000000002 |  | NO
 |  |  | Topsy Turvy |  |  | 3 | EA | - | 0 | 32.8 | 2.7488 | 1.45942 | 37.00822 |  | 47 | 19.99 | 19.99 | 39.98 | 2.971779999999995
 |  |  | Topsy Turvy |  |  | 4 | EA | - | 0 | 42.75 | 3.2288 | 1.69142 | 47.67022 |  | 47.99 | 23.99 | 23.99 | 47.98 | 0.3097799999999964
 |  |  | Topsy Turvy |  |  | 5 | EA | - | 0 | 50.7 | 5.1488 | 2.09742 | 57.94622 |  |  | 39.99 | 21.99 | 61.98 | 4.03378
 |  |  | Topsy Turvy |  |  | 6 | EA | - | 0 | 58.65 | 6.2288 | 2.35842 | 67.23722 |  | 71.29 | 48.99 | 21.99 | 70.98 | 3.74278000000001
 |  |  | Topsy Turvy |  |  | 8 | EA | - | 0 | 78.55 | 8.1488 | 3.054419999999999 | 89.75321999999998 |  | 96.48 | 64.99 | 29.99 | 94.97999999999999 | 5.226780000000005
 |  |  | Topsy Turvy |  |  | 10 | EA | - | 0 | 96.45 | 9.948799999999999 | 3.57642 | 109.97522 |  |  | 79.99 | 32.99 | 112.98 | 3.004779999999997
 |  |  | Topsy Turvy |  |  | 15 | EA | - | 0 | 138.2 | 15.9488 | 5.113420000000001 | 159.26222 |  |  | 129.99 | 35.99 | 165.98 | 6.717780000000033
 |  |  | Topsy Turvy |  |  | 20 | EA | - | 0 | 179.95 | 20.7488 | 6.38942 | 207.08822 |  |  | 169.99 | 39.99 | 209.98 | 2.891780000000011
 |  |  | ProCaulk |  |  | 1 | EA | - | 0 | 19.9 | 1.5488 | 0.9664200000000001 | 22.41522 |  |  | 9.99 | 12.99 | 22.98 | 0.5647800000000025
 |  |  | South Park Season 12 |  |  | 1 | EA | - | 0 | 30.89 | 0.47 | 1.28571 | 32.64571 |  |  | 1 | 32.99 | 33.99 | 1.344290000000001
 |  |  | Chill Out [NAME] |  |  | 1 | EA | - | 0 | 28.9 | 0.9488 | 1.31442 | 31.16322 |  |  | 4.99 | 29.99 | 34.98 | 3.816780000000001
 |  |  | Talking Bathroom Scale |  |  | 1 | EA | - | 0 | 25.9 | 0.9488 | 1.19842 | 28.04722 |  |  | 4.99 | 25.99 | 30.98 | 2.932780000000001
 |  |  | Corner [NAME] |  |  | 1 | EA | - | 0 | 30.9 | 0.9488 | 1.31442 | 33.16322 |  |  | 4.99 | 29.99 | 34.98 | 1.816780000000001
 |  |  | Corner [NAME] with Mat |  |  | 1 | EA | - | 0 | 38.85 | 0.9488 | 1.60442 | 41.40322 |  |  | 4.99 | 39.99 | 44.98 | 3.576780000000007
 |  |  | Coca Cola Can Shaped Glasses | 6 Pack |  | 1 | EA | - | 0 | 14.9 | 0.9488 | 0.85042 | 16.69922 |  |  | 4.99 | 13.99 | 18.98 | 2.28078
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 35.95 | 2.7488 | 1.45942 | 40.15822000000001 |  |  | 19.99 | 19.99 | 39.98 | -0.1782200000000103
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999
 |  |  |  |  |  | 1 | EA | - | 0 | 0 | 0.35 | 0.3 | 0.6499999999999999 |  |  |  |  | 0 | -0.6499999999999999