Spreadsheet: 774390d1648455314-how-to-filter-a-cell-dependant-on-3-other-cells-drawercosting
Sheet: HAR

[NAME] base |  | depth---->>>>>>>>>>>>>> |  |  |  |  |  |  | [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
 | 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
 |  |  |  |  |  |  |  |  | M-30H | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  | M-30H-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
M-85 | 12 | 12 | 12.5 | 13 | 13 | 14 |  |  | 0.6 |  |  |  |  |  |  |  | 0.6
K-120 | 15 | 16 | 15 | 15 | 15 | 18 |  |  | 0.7 |  |  |  |  |  |  |  | 0.7
H-150 |  | 18 | 18 | 18 | 17 | 19.5 |  |  | 0.8 |  |  |  |  |  |  |  | 0.8
D-213 | 15 | 16 | 15 | 15 | 15 | 18 |  |  | 0.9 |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2
[NAME] In Brac | Each
M | 3.3 | pr |  |  |  |  |  |  | K-30H | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  | K-30H-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
K | 7 | pr |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  | 0.3
H | 8.5 | pr |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  | 0.6
Soft Close |  | 10 | ea |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  | 0.7
[NAME] | M,K,H | 2.1 | ea |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  | 0.8
Harnfile set |  | 12 |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9
Gallery set of 2 |  | 7 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
Boxsides 500mm |  | 6 | pr |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  | H-30H | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  | H-30H-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-30H | 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-30H | 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
 |  |  |  |  |  |  |  |  | [NAME] | 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-30H | 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