Spreadsheet: 28909d1223481496-formula-to-decrease-a-margin-in-connection-with-increasing-basic-value-markups-vlookup
Sheet: Sheet1

Supplier price | Margin |  | Buy | Sell
0 | 2 |  | 1.2625 | 2.525
10 | 1.998 |  | 0.5625 | 1.125
20 | 1.996 |  | 1.2625 | 2.525
30 | 1.994 |  | 1.2625 | 2.525
40 | 1.992 |  | 1.2625 | 2.525
50 | 1.99 |  | 1.5375 | 3.075
60 | 1.988 |  | 1.825 | 3.65
70 | 1.986 |  | 1.2625 | 2.525
80 | 1.984 |  | 0.7125000000000001 | 1.425
90 | 1.982 |  | 1.2625 | 2.525
100 | 1.98 |  | 1.4 | 2.8
110 | 1.978 |  | 1.4 | 2.8
120 | 1.976 |  | 1.4 | 2.8
130 | 1.974 |  | 1.4 | 2.8
140 | 1.972 |  | 1.4 | 2.8
150 | 1.97 |  | 1.4 | 2.8
160 | 1.968 |  | 0.7125000000000001 | 1.425
170 | 1.966 |  | 1.4 | 2.8
180 | 1.964 |  | 1.4 | 2.8
190 | 1.962 |  | 1.5375 | 3.075
200 | 1.96 |  | 1.4 | 2.8
210 | 1.958 |  | 1.4 | 2.8
220 | 1.956 |  | 1.95 | 3.9
230 | 1.954 |  | 1.95 | 3.9
240 | 1.952 |  | 1.95 | 3.9
250 | 1.95 |  | 2.1 | 4.2
260 | 1.948 |  | 1.4 | 2.8
270 | 1.946 |  | 1.825 | 3.65
280 | 1.944 |  | 2.2375 | 4.475
290 | 1.942 |  | 4.8875 | 9.775
300 | 1.94 |  | 5.7125 | 11.425
310 | 1.938 |  | 6.875 | 13.75
320 | 1.936 |  | 1.95 | 3.9
330 | 1.934 |  | 1.825 | 3.65
340 | 1.932 |  | 1.825 | 3.65
350 | 1.93 |  | 1.95 | 3.9
360 | 1.928 |  | 1.95 | 3.9
370 | 1.926 |  | 2.2375 | 4.475
380 | 1.924 |  | 2.65 | 5.300000000000001
390 | 1.922 |  | 3.35 | 6.7
400 | 1.92 |  | 1.2625 | 2.525
410 | 1.918 |  | 2.5125 | 5.025
420 | 1.916 |  | 2.5125 | 5.025
430 | 1.914 |  | 2.65 | 5.300000000000001
440 | 1.912 |  | 3.0625 | 6.125
450 | 1.91 |  | 3.35 | 6.7
460 | 1.908 |  | 4.050000000000001 | 8.100000000000001
470 | 1.906 |  | 9.375 | 18.75
480 | 1.904 |  | 2.2375 | 4.475
490 | 1.902 |  | 4.050000000000001 | 8.100000000000001
500 | 1.9 |  | 4.175 | 8.35
510 | 1.898 |  | 0.8375 | 1.675
520 | 1.896 |  | 1.95 | 3.9
530 | 1.894 |  | 1.95 | 3.9
540 | 1.892 |  | 3.35 | 6.7
550 | 1.89 |  | 4.325 | 8.65
560 | 1.888 |  | 4.325 | 8.65
570 | 1.886 |  | 21 | 41.916
580 | 1.884 |  | 0.9875 | 1.975
590 | 1.882 |  | 3.9 | 7.800000000000001
600 | 1.88 |  | 3.9 | 7.800000000000001
610 | 1.878 |  | 1.5375 | 3.075
620 | 1.876 |  | 4.325 | 8.65
630 | 1.874 |  | 2.7875 | 5.575
640 | 1.872 |  | 0.7125000000000001 | 1.425
650 | 1.87 |  | 2.7875 | 5.575
660 | 1.868 |  | 31.5 | 62.811
670 | 1.866 |  | 1.125 | 2.25
680 | 1.864 |  | 1.125 | 2.25
690 | 1.862 |  | 0.8375 | 1.675
700 | 1.86 |  | 1.2625 | 2.525
710 | 1.858 |  | 1.4 | 2.8
720 | 1.856 |  | 0.2 | 0.4
730 | 1.854 |  | 1.125 | 2.25
740 | 1.852 |  | 15.75 | 31.4685
750 | 1.85 |  | 16.125 | 32.21775
760 | 1.848 |  | 0.8375 | 1.675
770 | 1.846 |  | 0.9875 | 1.975
780 | 1.844 |  | 0.7125000000000001 | 1.425
790 | 1.842 |  | 0.8375 | 1.675
800 | 1.84 |  | 0.5625 | 1.125
810 | 1.838 |  | 18 | 35.964
820 | 1.836 |  | 0.475 | 0.95
830 | 1.834 |  | 0.425 | 0.8500000000000001
840 | 1.832 |  | 0.5625 | 1.125
850 | 1.83 |  | 1.125 | 2.25
860 | 1.828 |  | 23.375 | 46.6565
870 | 1.826 |  | 0.5625 | 1.125
880 | 1.824 |  | 0.7125000000000001 | 1.425
890 | 1.822 |  | 18.875 | 37.71225
900 | 1.82 |  | 1.2625 | 2.525
910 | 1.818 |  | 0.425 | 0.8500000000000001
920 | 1.816 |  | 0.2875 | 0.5750000000000001
930 | 1.814 |  | 5.437500000000001 | 10.875
940 | 1.812 |  | 0.8375 | 1.675
950 | 1.81 |  | 1.125 | 2.25
960 | 1.808 |  | 0.8375 | 1.675
970 | 1.806 |  | 0.9875 | 1.975
980 | 1.804 |  | 0.425 | 0.8500000000000001
990 | 1.802 |  | 4.1125 | 8.225
1000 | 1.8 |  | 0.425 | 0.8500000000000001
1010 | 1.798 |  | 5.575 | 11.15
1020 | 1.796 |  | 1.5375 | 3.075
1030 | 1.794 |  | 0.8375 | 1.675
1040 | 1.792 |  | 0.5 | 1
1050 | 1.79 |  | 7.000000000000001 | 14
1060 | 1.788 |  | 0.8375 | 1.675
1070 | 1.786 |  | 5.437500000000001 | 10.875
1080 | 1.784 |  | 1.325 | 2.65
1090 | 1.782 |  | 1.825 | 3.65
1100 | 1.78 |  | 0.9875 | 1.975
1110 | 1.778 |  | 73.125 | 145.22625
1120 | 1.776 |  | 0.425 | 0.8500000000000001
1130 | 1.774 |  | 0.425 | 0.8500000000000001
1140 | 1.772 |  | 0.2875 | 0.5750000000000001
1150 | 1.77 |  | 0.2875 | 0.5750000000000001
1160 | 1.768 |  | 3.9125 | 7.824999999999999
1170 | 1.766 |  | 4.8875 | 9.775
1180 | 1.764 |  | 3.2125 | 6.425
1190 | 1.762 |  | 2.2375 | 4.475
1200 | 1.76 |  | 0.9875 | 1.975
1210 | 1.758 |  | 0.8375 | 1.675
1220 | 1.756 |  | 32.625 | 65.05425
1230 | 1.754 |  | 5.7125 | 11.425
1240 | 1.752 |  | 0.05 | 0.1
1250 | 1.75 |  | 90.875 | 180.11425
1260 | 1.748 |  | 387.875 | 746.2715
1270 | 1.746 |  | 341.25 | 659.295
1280 | 1.744 |  | 218.125 | 427.08875
1290 | 1.742 |  | 493.125 | 937.9237499999999
1300 | 1.74 |  | 350.125 | 675.7412499999999
1310 | 1.738 |  | 456.25 | 871.4375
1320 | 1.736 |  | 170 | 334.22
1330 | 1.734 |  | 369.375 | 712.155
1340 | 1.732 |  | 118.75 | 234.8875
1350 | 1.73 |  | 386.1250000000001 | 742.9045000000001
1360 | 1.728 |  | 264 | 514.2719999999999
1370 | 1.726 |  | 82.75 | 164.176
1380 | 1.724 |  | 70.625 | 140.26125
1390 | 1.722 |  | 508.75 | 966.625
1400 | 1.72 |  | 160.125 | 315.126
1410 | 1.718 |  | 15 | 29.97
1420 | 1.716 |  | 23.125 | 46.1575
1430 | 1.714 |  | 0.8375 | 1.675
1440 | 1.712 |  | 5.575 | 11.15
1450 | 1.71 |  | 38.875 | 77.51675
1460 | 1.708 |  | 127.625 | 252.187
1470 | 1.706 |  | 26.375 | 52.6445
1480 | 1.704 |  | 13.5 | 26.973
1490 | 1.702 |  | 2.2375 | 4.475
1500 | 1.7 |  | 10 | 19.98
1510 | 1.698 |  | 12.125 | 24.22575000000001
1520 | 1.696 |  | 8.125 | 16.25
1530 | 1.694 |  | 34.75 | 69.2915
1540 | 1.692 |  | 25.125 | 50.1495
1550 | 1.69 |  | 37.75 | 75.2735
1560 | 1.688 |  | 37.75 | 75.2735
1570 | 1.686 |  | 186.125 | 365.5495
1580 | 1.684 |  | 1.825 | 3.65
1590 | 1.682 |  | 44.875 | 89.391
1600 | 1.68 |  | 149.5 | 294.814
1610 | 1.678 |  | 24.25 | 48.40300000000001
1620 | 1.676 |  | 73.5 | 145.971
1630 | 1.674 |  | 73.5 | 145.971
1640 | 1.672 |  | 40.75 | 81.174
1650 | 1.67 |  | 143.875 | 283.7215
1660 | 1.668 |  | 149.5 | 294.814
1670 | 1.666 |  | 73.5 | 145.971
1680 | 1.664 |  | 73.5 | 145.971
1690 | 1.662 |  | 26 | 51.896
1700 | 1.66 |  | 26 | 51.896
1710 | 1.658 |  | 151.75 | 298.9475
1720 | 1.656 |  | 88 | 174.592
1730 | 1.654 |  | 88 | 174.592
1740 | 1.652 |  | 202.875 | 397.635
1750 | 1.65 |  | 62.375 | 124.0015
1760 | 1.648 |  | 68 | 135.184
1770 | 1.646 |  | 209.625 | 410.8650000000001
1780 | 1.644 |  | 9.5 | 19
1790 | 1.642 |  | 16.375 | 32.71725
1800 | 1.64 |  | 12.25 | 24.4755
1810 | 1.638 |  | 51.25 | 101.9875
1820 | 1.636 |  | 15.625 | 31.21875
1830 | 1.634 |  | 108.5 | 214.83
1840 | 1.632 |  | 27.375 | 54.64050000000001
1850 | 1.63 |  | 89.625 | 177.816
1860 | 1.628 |  | 16.375 | 32.71725
1870 | 1.626 |  | 27.375 | 54.64050000000001
1880 | 1.624 |  | 42.625 | 84.909
1890 | 1.622 |  | 28.625 | 57.13550000000001
1900 | 1.62 |  | 269.375 | 524.7425
1910 | 1.618 |  | 181.375 | 356.2205
1920 | 1.616 |  | 5.85 | 11.7
1930 | 1.614 |  | 40 | 79.68
1940 | 1.612 |  | 174.375 | 342.82125
1950 | 1.61 |  | 82.875 | 164.424
1960 | 1.608 |  | 82.875 | 164.424
1970 | 1.606 |  | 88.125 | 174.84
1980 | 1.604 |  | 7.25 | 14.5
1990 | 1.602 |  | 383.5 | 737.8539999999999
2000 | 1.6 |  | 17.25 | 34.4655
2010 | 1.598 |  | 116.375 | 230.18975
2020 | 1.596 |  | 191 | 374.742
2030 | 1.594 |  | 57 | 113.43
2040 | 1.592 |  | 32.25 | 64.3065
2050 | 1.59 |  | 40.75 | 81.174
2060 | 1.588 |  | 33.5 | 66.799
2070 | 1.586 |  | 92.5 | 183.335
2080 | 1.584 |  | 62.87500000000001 | 124.9955
2090 | 1.582 |  | 62.87500000000001 | 124.9955
2100 | 1.58 |  | 138.625 | 273.64575
2110 | 1.578 |  | 18.625 | 37.21275
2120 | 1.576 |  | 18.125 | 36.21375
2130 | 1.574 |  | 40.75 | 81.174
2140 | 1.572 |  | 185.5 | 364.322
2150 | 1.57 |  | 31.25 | 62.3125
2160 | 1.568 |  | 45 | 89.64
2170 | 1.566 |  | 28.125 | 56.1375
2180 | 1.564 |  | 89 | 176.576
2190 | 1.562 |  | 95.5 | 189.281
2200 | 1.56 |  | 54.75000000000001 | 108.9525
2210 | 1.558 |  | 35.75 | 71.2855
2220 | 1.556 |  | 17.25 | 34.4655
2230 | 1.554 |  | 72.625 | 144.23325
2240 | 1.552 |  | 1121.375 | 1991.562
2250 | 1.55 |  | 317.125 | 614.58825
2260 | 1.548 |  | 317.125 | 614.58825
2270 | 1.546 |  | 28.5 | 56.886
2280 | 1.544 |  | 79.75 | 158.3835
2290 | 1.542 |  | 47.125 | 93.873
2300 | 1.54 |  | 132.125 | 260.81475
2310 | 1.538 |  | 46.875 | 93.375
2320 | 1.536 |  | 45.875 | 91.383
2330 | 1.534 |  | 16.125 | 32.21775
2340 | 1.532 |  | 18.5 | 36.963
2350 | 1.53 |  | 18.125 | 36.21375
2360 | 1.528 |  | 7.375 | 14.75
2370 | 1.526 |  | 25.125 | 50.1495
2380 | 1.524 |  | 64.375 | 127.9775
2390 | 1.522 |  | 16.25 | 32.4675
2400 | 1.52 |  | 13.5 | 26.973
2410 | 1.518 |  | 25.875 | 51.6465
2420 | 1.516 |  | 66.5 | 132.202
2430 | 1.514 |  | 9.25 | 18.5
2440 | 1.512 |  | 2454.875 | 3706.86125
2450 | 1.51 |  | 5.7125 | 11.425
2460 | 1.508 |  | 76.875 | 152.67375
2470 | 1.506 |  | 71.875 | 142.74375
2480 | 1.504 |  | 39.75 | 79.2615
2490 | 1.502 |  | 15.625 | 31.21875
2500 | 1.5 |  | 34.75 | 69.2915
2510 | 1.498 |  | 64.625 | 128.4745
2520 | 1.496 |  | 66.5 | 132.202
2530 | 1.494 |  | 106.375 | 210.6225
2540 | 1.492 |  | 106.375 | 210.6225
2550 | 1.49 |  | 68.625 | 136.4265
2560 | 1.488 |  | 64.75 | 128.723
2570 | 1.486 |  | 71.125 | 141.25425
2580 | 1.484 |  | 73.625 | 146.21925
2590 | 1.482 |  | 90.25 | 178.8755
2600 | 1.48 |  | 69.375 | 137.9175
2610 | 1.478 |  | 69.375 | 137.9175
2620 | 1.476 |  | 45.37500000000001 | 90.38700000000001
2630 | 1.474 |  | 30.625 | 61.06625
2640 | 1.472 |  | 44.12500000000001 | 87.89700000000002
2650 | 1.47 |  | 47 | 93.624
2660 | 1.468 |  | 91.125 | 180.60975
2670 | 1.466 |  | 91.125 | 180.60975
2680 | 1.464 |  | 91.125 | 180.60975
2690 | 1.462 |  | 110.375 | 218.32175
2700 | 1.46 |  | 98.125 | 194.48375
2710 | 1.458 |  | 18 | 35.964
2720 | 1.456 |  | 45.75 | 91.134
2730 | 1.454 |  | 31.25 | 62.3125
2740 | 1.452 |  | 52.25000000000001 | 103.9775
2750 | 1.45 |  | 44.375 | 88.395
2760 | 1.448 |  | 408.0000000000001 | 783.3600000000001
2770 | 1.446 |  | 502.75 | 955.2249999999999
2780 | 1.444 |  | 294.125 | 571.19075
2790 | 1.442 |  | 294.125 | 571.19075
2800 | 1.44 |  | 51.00000000000001 | 101.49
2810 | 1.438 |  | 269.75 | 525.473
2820 | 1.436 |  | 8.375 | 16.75
2830 | 1.434 |  | 4.050000000000001 | 8.100000000000001
2840 | 1.432 |  | 53.375 | 106.21625
2850 | 1.43 |  | 54.75000000000001 | 108.9525
2860 | 1.428 |  | 51.375 | 102.23625
2870 | 1.426 |  | 39.75 | 79.2615
2880 | 1.424 |  | 48.125 | 95.865
2890 | 1.422 |  | 66.75 | 132.699
2900 | 1.42 |  | 87.5 | 173.6
2910 | 1.418 |  | 2.65 | 5.300000000000001
2920 | 1.416 |  | 100.75 | 199.485
2930 | 1.414 |  | 43.25 | 86.154
2940 | 1.412 |  | 31.5 | 62.811
2950 | 1.41 |  | 18.375 | 36.71325
2960 | 1.408 |  | 48.25 | 96.114
2970 | 1.406 |  | 88.5 | 175.584
2980 | 1.404 |  | 55.125 | 109.69875
2990 | 1.402 |  | 67.75 | 134.687
3000 | 1.4 |  | 67.75 | 134.687
 |  |  | 70.625 | 140.26125
 |  |  | 347.875 | 672.0944999999999
 |  |  | 631.25 | 1182.9625
 |  |  | 262.125 | 510.6195
 |  |  | 19.125 | 38.21175
 |  |  | 29.125 | 58.1335
 |  |  | 134.375 | 265.25625
 |  |  | 41.25 | 82.17
 |  |  | 412.5 | 791.175
 |  |  | 22.75 | 45.409
 |  |  | 7.25 | 14.5
 |  |  | 33.5 | 66.799