Spreadsheet: 703550d1605042095-i-need-help-on-an-if-then-table-weightdistance
Sheet: Sheet1

 |  | Weight (lbs) | Break Point | Weight (lbs) | Break Point | Weight (lbs) | Break Point | Weight (lbs) | Break Point | Weight (lbs) | Break Point | Weight (lbs) | Break Point | Weight (lbs) |  | Distance | Weight
[NAME] |  | 500 | 999 | 1000 | 1999 | 2000 | 3999 | 4000 | 7999 | 8000 | 11999 | 12000 | 15999 | 16000 |  | 125 | 3998
36 | 50 | 72.5 | 661 | 47.9 | 1575 | 37.7 | 3353 | 31.6 | 6292 | 24.85 | 10817 | 22.4 | 14715 | 20.6
51 | 60 | 74.85 | 654 | 48.95 | 1594 | 39 | 3359 | 32.75 | 6291 | 25.75 | 10999 | 23.6 | 14441 | 21.3
61 | 70 | 78.05 | 658 | 51.35 | 1562 | 40.1 | 3357 | 33.65 | 6241 | 26.25 | 11246 | 24.6 | 14212 | 21.85
71 | 80 | 81.05 | 661 | 53.55 | 1560 | 41.75 | 3320 | 34.65 | 6419 | 27.8 | 10986 | 25.45 | 14837 | 23.6
81 | 90 | 84 | 660 | 55.4 | 1551 | 42.95 | 3307 | 35.5 | 6547 | 29.05 | 10782 | 26.1 | 14989 | 24.45
91 | 100 | 86.45 | 660 | 57.05 | 1543 | 44 | 3278 | 36.05 | 6602 | 29.75 | 10589 | 26.25 | 15147 | 24.85
101 | 110 | 88.9 | 658 | 58.45 | 1537 | 44.9 | 3252 | 36.5 | 6696 | 30.55 | 10685 | 27.2 | 14795 | 25.15
111 | 120 | 91.35 | 665 | 60.7 | 1519 | 46.1 | 3228 | 37.2 | 6656 | 30.95 | 10643 | 27.45 | 14864 | 25.5
121 | 130 | 93.4 | 671 | 62.6 | 1529 | 47.85 | 3169 | 37.9 | 6713 | 31.8 | 10472 | 27.75 | 14991 | 26
131 | 140 | 95.75 | 676 | 64.65 | 1523 | 49.2 | 3143 | 38.65 | 6769 | 32.7 | 10514 | 28.65 | 15191 | 27.2
141 | 150 | 98.65 | 671 | 66.15 | 1509 | 49.9 | 3127 | 39 | 6811 | 33.2 | 10663 | 29.5 | 14943 | 27.55
151 | 160 | 100.95 | 672 | 67.75 | 1510 | 51.15 | 3144 | 40.2 | 6806 | 34.2 | 10720 | 30.55 | 14979 | 28.6
161 | 170 | 103.35 | 674 | 69.65 | 1511 | 52.6 | 3149 | 41.4 | 6793 | 35.15 | 10567 | 30.95 | 15096 | 29.2
171 | 180 | 106.3 | 670 | 71.2 | 1493 | 53.15 | 3195 | 42.45 | 6738 | 35.75 | 10675 | 31.8 | 15120 | 30.05
181 | 190 | 109.05 | 666 | 72.55 | 1495 | 54.2 | 3174 | 43 | 6828 | 36.7 | 10693 | 32.7 | 15071 | 30.8
191 | 200 | 110.85 | 671 | 74.35 | 1477 | 54.9 | 3184 | 43.7 | 6838 | 37.35 | 10956 | 34.1 | 14921 | 31.8
201 | 220 | 113.7 | 668 | 75.9 | 1489 | 56.5 | 3179 | 44.9 | 6887 | 38.65 | 10914 | 35.15 | 15113 | 33.2
221 | 240 | 116.65 | 666 | 77.65 | 1491 | 57.85 | 3188 | 46.1 | 6873 | 39.6 | 11061 | 36.5 | 14992 | 34.2
241 | 260 | 119.2 | 670 | 79.85 | 1506 | 60.1 | 3125 | 46.95 | 6859 | 40.25 | 11136 | 37.35 | 15208 | 35.5
261 | 280 | 122.25 | 669 | 81.75 | 1501 | 61.35 | 3150 | 48.3 | 6974 | 42.1 | 11074 | 38.85 | 15321 | 37.2
281 | 300 | 124.95 | 667 | 83.25 | 1514 | 63 | 3124 | 49.2 | 6952 | 42.75 | 11285 | 40.2 | 15384 | 38.65
301 | 320 | 128.1 | 670 | 85.7 | 1509 | 64.65 | 3150 | 50.9 | 7018 | 44.65 | 11315 | 42.1 | 15221 | 40.05
321 | 340 | 130.5 | 676 | 88.1 | 1502 | 66.15 | 3142 | 51.95 | 7038 | 45.7 | 11475 | 43.7 | 15360 | 41.95
341 | 360 | 133.85 | 674 | 90.1 | 1497 | 67.4 | 3164 | 53.3 | 7047 | 46.95 | 11477 | 44.9 | 15323 | 43
361 | 380 | 136.15 | 679 | 92.35 | 1498 | 69.15 | 3147 | 54.4 | 7103 | 48.3 | 11454 | 46.1 | 15272 | 44
381 | 400 | 138.65 | 676 | 93.7 | 1503 | 70.4 | 3171 | 55.8 | 7069 | 49.3 | 11477 | 47.15 | 15508 | 45.7
401 | 420 | 141.05 | 679 | 95.75 | 1490 | 71.3 | 3212 | 57.25 | 7148 | 51.15 | 11543 | 49.2 | 15269 | 46.95
421 | 440 | 144.3 | 680 | 98 | 1471 | 72.05 | 3212 | 57.85 | 7274 | 52.6 | 11453 | 50.2 | 15395 | 48.3
441 | 460 | 146.55 | 679 | 99.45 | 1479 | 73.5 | 3206 | 58.9 | 7253 | 53.4 | 11641 | 51.8 | 15228 | 49.3
461 | 480 | 149.25 | 676 | 100.75 | 1476 | 74.35 | 3250 | 60.4 | 7272 | 54.9 | 11618 | 53.15 | 15398 | 51.15
481 | 500 | 152.7 | 673 | 102.7 | 1471 | 75.5 | 3256 | 61.45 | 7311 | 56.15 | 11584 | 54.2 | 15528 | 52.6
501 | 520 | 154.95 | 672 | 104.05 | 1482 | 77.1 | 3282 | 63.25 | 7242 | 57.25 | 11508 | 54.9 | 15490 | 53.15
521 | 540 | 156.8 | 673 | 105.5 | 1494 | 78.8 | 3285 | 64.7 | 7154 | 57.85 | 11575 | 55.8 | 15312 | 53.4
541 | 560 | 159.25 | 673 | 107.15 | 1491 | 79.85 | 3287 | 65.6 | 7129 | 58.45 | 11600 | 56.5 | 15406 | 54.4
561 | 580 | 161.1 | 670 | 107.9 | 1500 | 80.9 | 3318 | 67.1 | 7136 | 59.85 | 11479 | 57.25 | 15581 | 55.75
581 | 600 | 163.25 | 670 | 109.35 | 1498 | 81.9 | 3309 | 67.75 | 7168 | 60.7 | 11477 | 58.05 | 15573 | 56.5
601 | 620 | 164.5 | 674 | 110.75 | 1504 | 83.25 | 3323 | 69.15 | 7243 | 62.6 | 11473 | 59.85 | 15412 | 57.65
621 | 640 | 166.7 | 673 | 112.15 | 1507 | 84.45 | 3335 | 70.4 | 7188 | 63.25 | 11460 | 60.4 | 15378 | 58.05
641 | 660 | 167.7 | 676 | 113.25 | 1514 | 85.7 | 3328 | 71.3 | 7187 | 64.05 | 11467 | 61.2 | 15399 | 58.9
661 | 680 | 169.15 | 676 | 114.2 | 1514 | 86.4 | 3350 | 72.35 | 7155 | 64.7 | 11611 | 62.6 | 15438 | 60.4
681 | 700 | 170.9 | 680 | 116.1 | 1518 | 88.1 | 3342 | 73.6 | 7191 | 66.15 | 11620 | 64.05 | 15638 | 62.6
701 | 725 | 172.7 | 680 | 117.4 | 1515 | 88.9 | 3359 | 74.65 | 7202 | 67.2 | 11572 | 64.8 | 15618 | 63.25
726 | 750 | 173.95 | 682 | 118.55 | 1522 | 90.2 | 3349 | 75.5 | 7291 | 68.8 | 11538 | 66.15 | 15638 | 64.65
751 | 775 | 175.85 | 685 | 120.35 | 1524 | 91.7 | 3364 | 77.1 | 7279 | 70.15 | 11496 | 67.2 | 15584 | 65.45
776 | 800 | 177.05 | 688 | 121.8 | 1526 | 92.9 | 3383 | 78.55 | 7252 | 71.2 | 11596 | 68.8 | 15431 | 66.35