Spreadsheet: 167950d1342167081-help-with-a-formula-to-work-out-average-difference-in-cost-formula
Sheet: Sheet1

 | Length (cm) | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300 | 310 | 320 | 330 | 340 | 350 | 360 | 370 | 380 | 390 | 400 | 410 | 420 | 430 | 440 | 450 | 460 | 470 | 480 | 490 | 500 | 510 | 520 | 530 | 540 | 550 | 560 | 570 | 580 | 590 | 600 | 610 | 620 | 630 | 640 | 650 | 660 | 670 | 680 | 690 | 700 | 710 | 720 | 730 | 740 | 750 | 760 | 770 | 780 | 790 | 800 | 810 | 820 | 830 | 840 | 850 | 860 | 870 | 880 | 890 | 900 | 910 | 920 | 930 | 940 | 950 | 960 | 970 | 980 | 990 | 1000 | 1010 | 1020 | 1030 | 1040 | 1050 | 1060 | 1070 | 1080 | 1090 | 1100 | 1110 | 1120 | 1130 | 1140 | 1150 | 1160 | 1170 | 1180 | 1190 | 1200 | 1210 | 1220 | 1230 | 1240 | 1250 | 1260 | 1270 | 1280 | 1290 | 1300 | 1310 | 1320 | 1330 | 1340 | 1350 | 1360 | 1370 | 1380 | 1390 | 1400 | 1410 | 1420 | 1430 | 1440 | 1450 | 1460 | 1470 | 1480 | 1490 | 1500
 | Price 1 | 6.95 | 8.34 | 9.73 | 11.12 | 12.51 | 13.9 | 15.29 | 16.68 | 18.07 | 19.46 | 20.85 | 22.24 | 23.63 | 25.02 | 26.41 | 27.8 | 29.19 | 30.58 | 31.97 | 33.36 | 34.75 | 36.14 | 37.53 | 38.92 | 40.31 | 41.7 | 43.09 | 44.48 | 45.87 | 47.26 | 48.65 | 50.04 | 51.43 | 52.82 | 54.21 | 55.6 | 56.99 | 58.38 | 59.77 | 61.16 | 62.55 | 63.94 | 65.33 | 66.72 | 68.11 | 69.5 | 70.89 | 72.28 | 73.67 | 75.06 | 76.45 | 77.84 | 79.23 | 80.62 | 82.01 | 83.4 | 84.79 | 86.18 | 87.57 | 88.96 | 90.35 | 91.74 | 93.13 | 94.52 | 95.91 | 97.3 | 98.69 | 100.08 | 101.47 | 102.86 | 104.25 | 105.64 | 107.03 | 108.42 | 109.81 | 111.2 | 112.59 | 113.98 | 115.37 | 116.76 | 118.15 | 119.54 | 120.93 | 122.32 | 123.71 | 125.1 | 126.49 | 127.88 | 129.27 | 130.66 | 132.05 | 133.44 | 134.83 | 136.22 | 137.61 | 139 | 140.39 | 141.78 | 143.17 | 144.56 | 145.95 | 147.34 | 148.73 | 150.12 | 151.51 | 152.9 | 154.29 | 155.68 | 157.07 | 158.46 | 159.85 | 161.24 | 162.63 | 164.02 | 165.41 | 166.8 | 168.19 | 169.58 | 170.97 | 172.36 | 173.75 | 175.14 | 176.53 | 177.92 | 179.31 | 180.7 | 182.09 | 183.48 | 184.87 | 186.26 | 187.65 | 189.04 | 190.43 | 191.82 | 193.21 | 194.6 | 195.99 | 197.38 | 198.77 | 200.16 | 201.55 | 202.94 | 204.33 | 205.72 | 207.11 | 208.5
 | Price 2 | 31.11999999999998 | 32.50999999999999 | 33.89999999999998 | 35.28999999999998 | 36.68 | 38.07 | 39.46 | 40.85 | 42.24 | 43.63 | 45.02 | 46.41 | 47.8 | 49.19 | 50.58 | 51.97000000000001 | 53.36000000000001 | 54.75000000000001 | 56.14 | 57.53 | 58.92 | 60.31000000000001 | 61.70000000000001 | 63.09 | 64.48 | 65.87 | 67.26 | 68.65 | 70.03999999999999 | 71.43 | 72.82000000000001 | 74.21000000000001 | 75.6 | 76.99 | 78.38 | 79.77 | 81.16 | 82.55000000000001 | 83.94 | 85.33 | 86.72 | 88.11 | 89.5 | 90.89 | 92.28 | 93.67 | 95.05999999999999 | 96.45 | 97.84 | 99.23 | 100.62 | 102.01 | 103.4 | 104.79 | 106.18 | 107.57 | 108.96 | 110.35 | 111.74 | 113.13 | 114.52 | 115.91 | 117.3 | 118.69 | 120.08 | 121.47 | 122.86 | 124.25 | 125.64 | 127.03 | 128.42 | 129.81 | 131.2 | 132.59 | 133.98 | 135.37 | 136.76 | 138.15 | 139.54 | 140.9300000000001 | 142.32 | 143.71 | 145.1000000000001 | 146.4900000000001 | 147.8800000000001 | 149.27 | 150.6600000000001 | 152.0500000000001 | 153.4400000000001 | 154.8300000000001 | 156.2200000000001 | 157.6100000000001 | 159.0000000000001 | 160.3900000000001 | 161.7800000000001 | 163.17 | 164.56 | 165.95 | 167.34 | 168.73 | 170.12 | 171.51 | 172.9 | 174.29 | 175.68 | 177.07 | 178.46 | 179.85 | 181.24 | 183.63 | 186.02 | 188.41 | 190.8 | 193.19 | 195.58 | 197.97 | 200.36 | 202.75 | 205.14 | 207.53 | 209.92 | 212.31 | 214.7 | 217.09 | 219.48 | 221.87 | 224.26 | 226.65 | 229.04 | 231.43 | 233.82 | 236.21 | 238.6 | 240.99 | 243.38 | 245.77 | 248.16 | 250.55 | 252.94 | 255.33 | 257.72 | 260.11 | 262.5 | 264.89 | 267.28 | 269.67
 | Price 3 | 71.11999999999999 | 72.50999999999999 | 73.89999999999998 | 75.28999999999999 | 76.68 | 78.07 | 79.46000000000001 | 80.85 | 82.24000000000001 | 83.63 | 85.02 | 86.41 | 87.8 | 89.19 | 90.58 | 91.97 | 93.36000000000001 | 94.75 | 96.14 | 97.53 | 98.92 | 100.31 | 101.7 | 103.09 | 104.48 | 105.87 | 107.26 | 108.65 | 110.04 | 111.43 | 112.82 | 114.21 | 115.6 | 116.99 | 118.38 | 119.77 | 121.16 | 122.55 | 123.94 | 125.33 | 126.72 | 128.11 | 129.5 | 130.89 | 132.28 | 133.67 | 115.06 | 116.45 | 117.84 | 119.23 | 120.62 | 122.01 | 123.4 | 124.79 | 126.18 | 127.57 | 128.96 | 130.35 | 131.74 | 133.13 | 134.52 | 135.91 | 137.3 | 138.69 | 140.08 | 141.47 | 142.86 | 144.25 | 145.64 | 147.03 | 148.42 | 149.81 | 151.2 | 152.59 | 153.98 | 155.37 | 156.76 | 158.15 | 159.54 | 160.9300000000001 | 162.32 | 163.71 | 165.1000000000001 | 166.4900000000001 | 167.8800000000001 | 169.27 | 170.6600000000001 | 172.0500000000001 | 173.4400000000001 | 174.8300000000001 | 176.2200000000001 | 177.6100000000001 | 179.0000000000001 | 180.3900000000001 | 181.7800000000001 | 183.17 | 184.56 | 185.95 | 187.34 | 188.73 | 190.12 | 191.51 | 192.9 | 194.29 | 195.68 | 197.07 | 198.46 | 199.85 | 201.24 | 202.63 | 204.02 | 205.41 | 206.8 | 208.19 | 209.58 | 210.97 | 212.36 | 213.75 | 215.14 | 216.53 | 217.92 | 219.31 | 220.7 | 222.09 | 223.48 | 224.87 | 226.26 | 227.65 | 229.04 | 230.43 | 231.82 | 233.21 | 234.6 | 235.99 | 237.38 | 238.77 | 240.16 | 241.55 | 242.94 | 244.33 | 245.72 | 247.11 | 248.5 | 249.89 | 251.28 | 252.67