Spreadsheet: 774375d1648442375-how-to-filter-a-cell-dependant-on-3-other-cells-drawercosting
Sheet: LEG

[NAME] base |  |  |  |  |  |  |  |  |  | [NAME] cost N,M |  |  |  |  |  |  |  |  | Whiteboard cost K |  |  |  |  |  |  |  |  | [NAME] cost C,F
 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
0.3 |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
0.4 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
0.5 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
0.6 |  |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
0.7 |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
0.8 |  |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
0.9 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
1.1 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
1.2 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
[NAME] back |  |  |  |  |  |  |  |  |  | N-40 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | M-70 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
 | N,M | K | C,F |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
Column1 | 0.063 | 0.101 | 0.22 |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
0.3 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
0.4 |  |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
0.5 |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
0.6 |  |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
0.7 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
0.8 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
0.9 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
1 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
1.1
1.2
 |  |  |  |  |  |  |  |  |  | M-40 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | K-70 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
Whiteboard |  | 35.5 | M2 |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
Sides | 270 | 350 | 400 | 450 | 500 | 550 | 600 | Inners |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
N |  |  |  | 33.5 | 35.5 |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
M | 27.5 | 27.5 | 28 | 28 | 28.5 | 31 | 35.5 |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
K |  | 34 | 34.5 | 35 | 35.5 | 39.5 |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
C |  | 44.5 | 45 | 45.5 | 47.5 | 49 | 54.5 |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
F |  |  |  | 73.5 | 74 | 77 | 83.5 |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
Runners | 270 | 350 | 400 | 450 | 500 | 550 | 600 |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
40 kg | 33.5 | 32.5 | 33 | 33.5 | 33.5 | 36
70 kg |  |  |  | 41 | 41.5 | 43.5 | 48 |  |  | K-40
 |  |  |  |  |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | C-70 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
Back Brac |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
N | 2.5 | ea |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
M | 2 | ea |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
K | 2.2 | ea |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
C | 2.5 | ea |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
F | 5 | ea |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
In [NAME] |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
M | 19 | ea |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
K | 19 | ea |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
C | 25.5 | ea
 |  |  |  |  |  |  |  |  |  | C-40
[NAME] |  |  |  |  |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | F-70 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
N | 2 | ea |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
M | 2 | ea |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
K | 2 | ea |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
[NAME] | 1043mm | 23 |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
Cross Gal | 1080[NAME] | 9 |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
Side Stab |  | 32 | set |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  |  | F-40
 |  |  |  |  |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
 |  |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  |  | 0.8
 |  |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  |  | M-40-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | M-70-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
 |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  |  | K-40-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | [NAME] | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
 |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  |  | C-40-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | C-70-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
 |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2