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

[NAME] base |  |  |  |  |  |  |  |  | [NAME] cost N,M |  |  |  |  |  |  |  | Whiteboard cost K |  |  |  |  |  |  |  | [NAME] cost H,B,D
 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
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 |  |  |  |  |  |  |  |  | [NAME] cost Inner N,M |  |  |  |  |  |  |  | [NAME] cost [NAME] |  |  |  |  |  |  |  | [NAME] cost Inner H,B,D
 | N,M | K | H,B,D |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
Column1 | 0.071 | 0.113 | 0.2 |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  | N-25 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  | N-25-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
Whiteboard |  | 35.5 | M2 |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.4
Sides | 270 | 350 | 400 | 450 | 500 | 550 | Inners |  | 0.5 |  |  |  |  |  |  |  | 0.5
N | 13.5 | 13.5 | 13.5 | 14 | 14 | 15 |  |  | 0.6 |  |  |  |  |  |  |  | 0.6
M | 12 | 12 | 12.5 | 13 | 13 | 14 |  |  | 0.7 |  |  |  |  |  |  |  | 0.7
K | 15 | 16 | 15 | 15 | 15 | 18 |  |  | 0.8 |  |  |  |  |  |  |  | 0.8
H |  | 18 | 18 | 18 | 17 | 19.5 |  |  | 0.9 |  |  |  |  |  |  |  | 0.9
B | 12 | 12 | 12.5 | 13 | 13 | 14 |  |  | 1 |  |  |  |  |  |  |  | 1
D | 15 | 16 | 15 | 15 | 15 | 18 |  |  | 1.1 |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2
Gal Rails | 270 | 350 | 400 | 450 | 500 | 550 |  |  | M-25 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  | M-25-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
B | 15 | 15 | 15 | 15 | 15 | 15 |  |  | 0.3 |  |  |  |  |  |  |  | 0.3
D | 15 | 15 | 15 | 15 | 15 | 15 |  |  | 0.4 |  |  |  |  |  |  |  | 0.4
DD | 30 | 30 | 30 | 30 | 30 | 30 |  |  | 0.5 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  | 0.6
[NAME] In Brac | Each |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  | 0.7
N | 3.3 |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  | 0.8
M | 3.3 |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9
K | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
H | 4.4 |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2
Blumotion |  | 10
Door Saver |  | 5 |  |  |  |  |  |  | K-25 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  | K-25-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
[NAME] | M,K,H | 2.1 | ea |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  | 0.3
[NAME] | N | 5 | ea |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.4
Cnr rail post |  | 3 |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.5
Gall Rail 1104[NAME] |  | 5.5 |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  | 0.6
Metafile |  | 33 |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  | 0.7
Gallery set of 2 |  | 15 |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  | 0.8
Boxsides |  | 8 |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  | H-25 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  | H-25-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
 |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  | MB-25 | 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
 |  |  |  |  |  |  |  |  | MD-25 | 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
 |  |  |  |  |  |  |  |  | KB-25 | 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
 |  |  |  |  |  |  |  |  | HB-25 | 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