Spreadsheet: 75953d1276547744-vlookup-error-list-work
Sheet: List work

 |  |  |  | 1.1 | variable cost input
 |  |  |  |  | ERROR? Why
cost | price | price rounded
17 | 0.5775 | 0.58
17.25 | 0.58 | 0.58
17.5 | 0.5825 | 0.59
17.75 | 0.585 | 0.59
18 | 0.5875 | 0.59
18.25 | 0.59 | 0.59
18.5 | 0.5925 | 0.6
18.75 | 0.595 | 0.6
19 | 0.5975 | 0.6
19.25 | 0.6 | 0.6
19.5 | 0.6025 | 0.61
19.75 | 0.605 | 0.61
20 | 0.6075 | 0.61
20.25 | 0.61 | 0.61
20.5 | 0.6124999999999999 | 0.62
20.75 | 0.615 | 0.62
21 | 0.6174999999999999 | 0.62
21.25 | 0.62 | 0.62
21.5 | 0.6224999999999999 | 0.63
21.75 | 0.625 | 0.63
22 | 0.6275 | 0.63
22.25 | 0.63 | 0.63
22.5 | 0.6325 | 0.64
22.75 | 0.635 | 0.64
23 | 0.6375 | 0.64
23.25 | 0.64 | 0.64
23.5 | 0.6425 | 0.65
23.75 | 0.645 | 0.65
24 | 0.6475 | 0.65
24.25 | 0.65 | 0.65
24.5 | 0.6525 | 0.66
24.75 | 0.655 | 0.66
25 | 0.6575 | 0.66
25.25 | 0.66 | 0.66
25.5 | 0.6625 | 0.67
25.75 | 0.665 | 0.67
26 | 0.6675 | 0.67
26.25 | 0.67 | 0.67
26.5 | 0.6725 | 0.68
26.75 | 0.6749999999999999 | 0.68
27 | 0.6775 | 0.68
27.25 | 0.68 | 0.68
27.5 | 0.6825 | 0.6900000000000001
27.75 | 0.6849999999999999 | 0.6900000000000001
28 | 0.6875 | 0.6900000000000001
28.25 | 0.69 | 0.69
28.5 | 0.6925 | 0.7
28.75 | 0.695 | 0.7
29 | 0.6975 | 0.7
29.25 | 0.7 | 0.7
29.5 | 0.7025 | 0.72
29.75 | 0.7075 | 0.72
30 | 0.7125 | 0.72
30.25 | 0.715 | 0.72
30.5 | 0.7175 | 0.72
30.75 | 0.72 | 0.72
31 | 0.7225 | 0.74
31.25 | 0.725 | 0.74
31.5 | 0.7275 | 0.74
31.75 | 0.7325 | 0.74
32 | 0.735 | 0.74
32.25 | 0.7374999999999999 | 0.74
32.5 | 0.74 | 0.74
32.75 | 0.745 | 0.75
33 | 0.7474999999999999 | 0.75
33.25 | 0.75 | 0.75
33.5 | 0.7525 | 0.79
33.75 | 0.7575 | 0.79
34 | 0.7625 | 0.79
34.25 | 0.765 | 0.79
34.5 | 0.7675 | 0.79
34.75 | 0.7725 | 0.79
35 | 0.775 | 0.79
35.25 | 0.7775 | 0.79
35.5 | 0.7825 | 0.79
35.75 | 0.7875 | 0.79
36 | 0.79 | 0.79
36.25 | 0.7925 | 0.8
36.5 | 0.795 | 0.8
36.75 | 0.8 | 0.8
37 | 0.8025 | 0.82
37.25 | 0.805 | 0.82
37.5 | 0.8075 | 0.82
37.75 | 0.8125 | 0.82
38 | 0.8175 | 0.82
38.25 | 0.82 | 0.82
38.5 | 0.825 | 0.83
38.75 | 0.83 | 0.83
39 | 0.8325 | 0.85
39.25 | 0.835 | 0.85
39.5 | 0.8375 | 0.85
39.75 | 0.8425 | 0.85
40 | 0.845 | 0.85
40.25 | 0.8475 | 0.85
40.5 | 0.85 | 0.85
40.75 | 0.855 | 0.86
41 | 0.86 | 0.86
41.25 | 0.8624999999999999 | 0.87
41.5 | 0.8649999999999999 | 0.87
41.75 | 0.87 | 0.87
42 | 0.8724999999999999 | 0.89
42.25 | 0.8749999999999999 | 0.89
42.5 | 0.8775000000000001 | 0.89
42.75 | 0.8825 | 0.89
43 | 0.8849999999999999 | 0.89
43.25 | 0.8875000000000001 | 0.89
43.5 | 0.89 | 0.89
43.75 | 0.8949999999999999 | 0.9
44 | 0.9 | 0.9
44.25 | 0.9025 | 0.91
44.5 | 0.9049999999999999 | 0.91
44.75 | 0.91 | 0.91
45 | 0.9125 | 0.92
45.25 | 0.9149999999999999 | 0.92
45.5 | 0.92 | 0.92
45.75 | 0.9249999999999999 | 0.93
46 | 0.9274999999999999 | 0.93
46.25 | 0.93 | 0.93
46.5 | 0.9325 | 0.94
46.75 | 0.9374999999999999 | 0.94
47 | 0.94 | 0.94
47.25 | 0.9425 | 0.9600000000000001
47.5 | 0.9474999999999999 | 0.9600000000000001
47.75 | 0.9525 | 0.9600000000000001
48 | 0.955 | 0.9600000000000001
48.25 | 0.9574999999999999 | 0.9600000000000001
48.5 | 0.9600000000000001 | 0.9600000000000001
48.75 | 0.965 | 0.9700000000000001
49 | 0.9674999999999999 | 0.9700000000000001
49.25 | 0.9700000000000001 | 0.9700000000000001
49.5 | 0.975 | 0.9800000000000001
49.75 | 0.9800000000000001 | 0.9800000000000001
50 | 0.9825 | 0.9899999999999999
50.25 | 0.985 | 0.9899999999999999
50.5 | 0.9874999999999999 | 0.9899999999999999
50.75 | 0.9899999999999999 | 0.9899999999999999
51 | 0.995 | 1.01
51.25 | 0.9974999999999999 | 1.01
51.5 | 1.0025 | 1.01
51.75 | 1.005 | 1.01
52 | 1.0075 | 1.01
52.25 | 1.01 | 1.01
52.5 | 1.0175 | 1.02
52.75 | 1.02 | 1.02
53 | 1.0225 | 1.03
53.25 | 1.025 | 1.03
53.5 | 1.0275 | 1.03
53.75 | 1.03 | 1.03
54 | 1.035 | 1.04
54.25 | 1.0375 | 1.04
54.5 | 1.04 | 1.04
54.75 | 1.0425 | 1.05
55 | 1.045 | 1.05
55.25 | 1.0475 | 1.05
55.5 | 1.05 | 1.05
55.75 | 1.055 | 1.06
56 | 1.0575 | 1.06
56.25 | 1.06 | 1.06
56.5 | 1.0625 | 1.07
56.75 | 1.0675 | 1.07
57 | 1.07 | 1.07
57.25 | 1.0725 | 1.08
57.5 | 1.0775 | 1.08
57.75 | 1.08 | 1.08
58 | 1.0825 | 1.09
58.25 | 1.085 | 1.09
58.5 | 1.09 | 1.09
58.75 | 1.095 | 1.1
59 | 1.0975 | 1.1
59.25 | 1.1 | 1.1
59.5 | 1.1025 | 1.11
59.75 | 1.1075 | 1.11
60 | 1.11 | 1.11
60.25 | 1.1125 | 1.13
60.5 | 1.1175 | 1.13
60.75 | 1.1225 | 1.13
61 | 1.125 | 1.13
61.25 | 1.1275 | 1.13
61.5 | 1.13 | 1.13
61.75 | 1.135 | 1.14
62 | 1.1375 | 1.14
62.25 | 1.14 | 1.14
62.5 | 1.145 | 1.15
62.75 | 1.15 | 1.15
63 | 1.1525 | 1.16
63.25 | 1.155 | 1.16
63.5 | 1.16 | 1.16
63.75 | 1.1625 | 1.17
64 | 1.165 | 1.17
64.25 | 1.1675 | 1.17
64.5 | 1.17 | 1.17
64.75 | 1.175 | 1.18
65 | 1.1775 | 1.18
65.25 | 1.18 | 1.18
65.5 | 1.185 | 1.2
65.75 | 1.1875 | 1.2
66 | 1.1925 | 1.2
66.25 | 1.195 | 1.2
66.5 | 1.1975 | 1.2
66.75 | 1.2 | 1.2
67 | 1.2025 | 1.21
67.25 | 1.205 | 1.21
67.5 | 1.21 | 1.21
67.75 | 1.2125 | 1.22
68 | 1.215 | 1.22
68.25 | 1.2175 | 1.22
68.5 | 1.22 | 1.22
68.75 | 1.2225 | 1.23
69 | 1.23 | 1.23
69.25 | 1.2325 | 1.24
69.5 | 1.235 | 1.24
69.75 | 1.2375 | 1.24
70 | 1.24 | 1.24
70.25 | 1.2425 | 1.25
70.5 | 1.2475 | 1.25
70.75 | 1.25 | 1.25
71 | 1.2525 | 1.26
71.25 | 1.255 | 1.26
71.5 | 1.2575 | 1.26
71.75 | 1.26 | 1.26
72 | 1.265 | 1.27
72.25 | 1.2675 | 1.27
72.5 | 1.27 | 1.27
72.75 | 1.2725 | 1.29
73 | 1.275 | 1.29
73.25 | 1.2775 | 1.29
73.5 | 1.2825 | 1.29
73.75 | 1.285 | 1.29
74 | 1.2875 | 1.29
74.25 | 1.29 | 1.29
74.5 | 1.2925 | 1.3
74.75 | 1.295 | 1.3
75 | 1.3 | 1.3
75.25 | 1.3025 | 1.31
75.5 | 1.305 | 1.31
75.75 | 1.3075 | 1.31
76 | 1.31 | 1.31
76.25 | 1.3125 | 1.32
76.5 | 1.32 | 1.32
76.75 | 1.3225 | 1.33
77 | 1.325 | 1.33
77.25 | 1.3275 | 1.33
77.5 | 1.33 | 1.33
77.75 | 1.3325 | 1.34
78 | 1.335 | 1.34
78.25 | 1.34 | 1.34
78.5 | 1.3425 | 1.35
78.75 | 1.345 | 1.35
79 | 1.3475 | 1.35
79.25 | 1.35 | 1.35
79.5 | 1.355 | 1.36
79.75 | 1.3575 | 1.36
80 | 1.36 | 1.36
80.25 | 1.3625 | 1.38
80.5 | 1.365 | 1.38
80.75 | 1.3675 | 1.38
81 | 1.3725 | 1.38
81.25 | 1.375 | 1.38
81.5 | 1.3775 | 1.38
81.75 | 1.38 | 1.38
82 | 1.3825 | 1.4
82.25 | 1.385 | 1.4
82.5 | 1.3925 | 1.4
82.75 | 1.395 | 1.4
83 | 1.3975 | 1.4
83.25 | 1.4 | 1.4
83.5 | 1.4025 | 1.41
83.75 | 1.405 | 1.41
84 | 1.41 | 1.41
84.25 | 1.4125 | 1.42
84.5 | 1.415 | 1.42
84.75 | 1.4175 | 1.42
85 | 1.42 | 1.42
85.25 | 1.4225 | 1.43
85.5 | 1.43 | 1.43
85.75 | 1.4325 | 1.44
86 | 1.435 | 1.44
86.25 | 1.4375 | 1.44
86.5 | 1.44 | 1.44
86.75 | 1.4425 | 1.45
87 | 1.45 | 1.45
87.25 | 1.4525 | 1.46
87.5 | 1.455 | 1.46
87.75 | 1.4575 | 1.46
88 | 1.46 | 1.46
88.25 | 1.4625 | 1.47
88.5 | 1.47 | 1.47
88.75 | 1.4725 | 1.48
89 | 1.475 | 1.48
89.25 | 1.4775 | 1.48
89.5 | 1.48 | 1.48
89.75 | 1.4825 | 1.49
90 | 1.49 | 1.49
90.25 | 1.4925 | 1.5
90.5 | 1.495 | 1.5
90.75 | 1.4975 | 1.5
91 | 1.5 | 1.5
91.25 | 1.5025 | 1.51
91.5 | 1.5075 | 1.51
91.75 | 1.51 | 1.51
92 | 1.5125 | 1.52
92.25 | 1.515 | 1.52
92.5 | 1.5175 | 1.52
92.75 | 1.52 | 1.52
93 | 1.5275 | 1.53
93.25 | 1.53 | 1.53
93.5 | 1.5325 | 1.54
93.75 | 1.535 | 1.54
94 | 1.5375 | 1.54
94.25 | 1.54 | 1.54
94.5 | 1.5475 | 1.55
94.75 | 1.55 | 1.55
95 | 1.5525 | 1.56
95.25 | 1.555 | 1.56
95.5 | 1.5575 | 1.56
95.75 | 1.56 | 1.56
96 | 1.5675 | 1.57
96.25 | 1.57 | 1.57
96.5 | 1.5725 | 1.58
96.75 | 1.575 | 1.58
97 | 1.5775 | 1.58
97.25 | 1.58 | 1.58
97.5 | 1.5875 | 1.59
97.75 | 1.59 | 1.59
98 | 1.5925 | 1.6
98.25 | 1.595 | 1.6
98.5 | 1.5975 | 1.6
98.75 | 1.6 | 1.6
99 | 1.6075 | 1.61
99.25 | 1.61 | 1.61
99.5 | 1.6125 | 1.65
99.75 | 1.615 | 1.65
100 | 1.6175 | 1.65
100.25 | 1.6225 | 1.65
100.5 | 1.625 | 1.65
100.75 | 1.6275 | 1.65
101 | 1.6325 | 1.65
101.25 | 1.635 | 1.65
101.5 | 1.6375 | 1.65
101.75 | 1.6425 | 1.65
102 | 1.645 | 1.65
102.25 | 1.6475 | 1.65
102.5 | 1.65 | 1.65
102.75 | 1.655 | 1.66
103 | 1.6575 | 1.66
103.25 | 1.66 | 1.66
103.5 | 1.6625 | 1.67
103.75 | 1.6675 | 1.67
104 | 1.67 | 1.67
104.25 | 1.6725 | 1.68
104.5 | 1.6775 | 1.68
104.75 | 1.68 | 1.68
105 | 1.6825 | 1.69
105.25 | 1.685 | 1.69
105.5 | 1.69 | 1.69
105.75 | 1.6925 | 1.7
106 | 1.695 | 1.7
106.25 | 1.7 | 1.7
106.5 | 1.7025 | 1.72
106.75 | 1.705 | 1.72
107 | 1.7075 | 1.72
107.25 | 1.7125 | 1.72
107.5 | 1.715 | 1.72
107.75 | 1.7175 | 1.72
108 | 1.72 | 1.72
108.25 | 1.725 | 1.73
108.5 | 1.7275 | 1.73
108.75 | 1.73 | 1.73
109 | 1.735 | 1.74
109.25 | 1.7375 | 1.74
109.5 | 1.74 | 1.74
109.75 | 1.7425 | 1.75
110 | 1.7475 | 1.75
110.25 | 1.75 | 1.75
110.5 | 1.7525 | 1.76
110.75 | 1.7575 | 1.76
111 | 1.76 | 1.76
111.25 | 1.7625 | 1.77
111.5 | 1.765 | 1.77
111.75 | 1.77 | 1.77
112 | 1.7725 | 1.8
112.25 | 1.775 | 1.8
112.5 | 1.7775 | 1.8
112.75 | 1.7825 | 1.8
113 | 1.785 | 1.8
113.25 | 1.7875 | 1.8
113.5 | 1.7925 | 1.8
113.75 | 1.795 | 1.8
114 | 1.7975 | 1.8
114.25 | 1.8 | 1.8
114.5 | 1.805 | 1.81
114.75 | 1.8075 | 1.81
115 | 1.81 | 1.81
115.25 | 1.815 | 1.82
115.5 | 1.8175 | 1.82
115.75 | 1.82 | 1.82
116 | 1.8225 | 1.83
116.25 | 1.8275 | 1.83
116.5 | 1.83 | 1.83
116.75 | 1.8325 | 1.84
117 | 1.8375 | 1.84
117.25 | 1.84 | 1.84
117.5 | 1.8425 | 1.85
117.75 | 1.845 | 1.85
118 | 1.85 | 1.85
118.25 | 1.8525 | 1.9
118.5 | 1.855 | 1.9
118.75 | 1.8575 | 1.9
119 | 1.8625 | 1.9
119.25 | 1.865 | 1.9
119.5 | 1.8675 | 1.9
119.75 | 1.8725 | 1.9
120 | 1.875 | 1.9
120.25 | 1.8775 | 1.9
120.5 | 1.8825 | 1.9
120.75 | 1.885 | 1.9
121 | 1.8875 | 1.9
121.25 | 1.8925 | 1.9
121.5 | 1.895 | 1.9
121.75 | 1.8975 | 1.9
122 | 1.9 | 1.9
122.25 | 1.905 | 1.91
122.5 | 1.9075 | 1.91
122.75 | 1.91 | 1.91
123 | 1.915 | 1.92
123.25 | 1.9175 | 1.92
123.5 | 1.92 | 1.92
123.75 | 1.9225 | 1.93
124 | 1.9275 | 1.93
124.25 | 1.93 | 1.93
124.5 | 1.9325 | 1.94
124.75 | 1.9375 | 1.94
125 | 1.94 | 1.94
125.25 | 1.9425 | 1.95
125.5 | 1.945 | 1.95
125.75 | 1.95 | 1.95
126 | 1.9525 | 1.98
126.25 | 1.955 | 1.98
126.5 | 1.9575 | 1.98
126.75 | 1.9625 | 1.98
127 | 1.965 | 1.98
127.25 | 1.9675 | 1.98
127.5 | 1.9725 | 1.98
127.75 | 1.975 | 1.98
128 | 1.9775 | 1.98
128.25 | 1.98 | 1.98
128.5 | 1.985 | 1.99
128.75 | 1.9875 | 1.99
129 | 1.99 | 1.99
129.25 | 1.995 | 2
129.5 | 1.9975 | 2
129.75 | 2 | 2
130 | 2.0025 | 2.01
130.25 | 2.0075 | 2.01
130.5 | 2.01 | 2.01
130.75 | 2.0125 | 2.02
131 | 2.015 | 2.02
131.25 | 2.02 | 2.02
131.5 | 2.0225 | 2.03
131.75 | 2.025 | 2.03
132 | 2.03 | 2.03
132.25 | 2.0325 | 2.06
132.5 | 2.035 | 2.06
132.75 | 2.0375 | 2.06
133 | 2.0425 | 2.06
133.25 | 2.045 | 2.06
133.5 | 2.0475 | 2.06
133.75 | 2.0525 | 2.06
134 | 2.055 | 2.06
134.25 | 2.0575 | 2.06
134.5 | 2.06 | 2.06
134.75 | 2.065 | 2.07
135 | 2.0675 | 2.07
135.25 | 2.07 | 2.07
135.5 | 2.075 | 2.08
135.75 | 2.0775 | 2.08
136 | 2.08 | 2.08
136.25 | 2.0825 | 2.09
136.5 | 2.0875 | 2.09
136.75 | 2.09 | 2.09
137 | 2.0925 | 2.1
137.25 | 2.095 | 2.1
137.5 | 2.1 | 2.1
137.75 | 2.1025 | 2.11
138 | 2.105 | 2.11
138.25 | 2.11 | 2.11
138.5 | 2.1125 | 2.14
138.75 | 2.115 | 2.14
139 | 2.1175 | 2.14
139.25 | 2.1225 | 2.14
139.5 | 2.125 | 2.14
139.75 | 2.1275 | 2.14
140 | 2.1325 | 2.14
140.25 | 2.135 | 2.14
140.5 | 2.1375 | 2.14
140.75 | 2.14 | 2.14
141 | 2.145 | 2.15
141.25 | 2.1475 | 2.15
141.5 | 2.15 | 2.15
141.75 | 2.155 | 2.16
142 | 2.1575 | 2.16
142.25 | 2.16 | 2.16
142.5 | 2.1625 | 2.17
142.75 | 2.1675 | 2.17
143 | 2.17 | 2.17
143.25 | 2.1725 | 2.18
143.5 | 2.175 | 2.18
143.75 | 2.18 | 2.18
144 | 2.1825 | 2.19
144.25 | 2.185 | 2.19
144.5 | 2.19 | 2.19
144.75 | 2.1925 | 2.22
145 | 2.195 | 2.22
145.25 | 2.1975 | 2.22
145.5 | 2.2025 | 2.22
145.75 | 2.205 | 2.22
146 | 2.2075 | 2.22
146.25 | 2.2125 | 2.22
146.5 | 2.215 | 2.22
146.75 | 2.2175 | 2.22
147 | 2.22 | 2.22
147.25 | 2.225 | 2.23
147.5 | 2.2275 | 2.23
147.75 | 2.23 | 2.23
148 | 2.235 | 2.24
148.25 | 2.2375 | 2.24
148.5 | 2.24 | 2.24
148.75 | 2.2425 | 2.25
149 | 2.2475 | 2.25
149.25 | 2.25 | 2.25
149.5 | 2.2525 | 2.26
149.75 | 2.255 | 2.26
150 | 2.26 | 2.26