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

[NAME] base and back |  |  |  |  |  |  |  |  |  |  | [NAME] cost N,M |  |  |  |  |  |  |  |  |  | Whiteboard cost K |  |  |  |  |  |  |  |  | [NAME] cost ,B,D
 | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  |  | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  |  | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  |  | 0.3 | 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,M | K | B,C,D |  |  |  |  |  |  | N-40S | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  |  | M-40S-IN | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
 | 0.084 | 0.116 | 0.2 |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  |  | 0.3
0.3 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  |  | 0.4
0.4 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  | 0.5
0.5 |  |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  |  | 0.6
0.6 |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  |  | 0.7
0.7 |  |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  |  | 0.8
0.8 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  |  | 0.9
0.9 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
1 |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  |  | 1.1
1.1 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  |  | 1.2
1.2
 |  |  |  |  |  |  |  |  |  | M-40S | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  | K-40S-IN | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
Whiteboard |  | 35.5 | M2 |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  |  | 0.4
Kits | 270 | 300 | 350 | 400 | 450 | 500 | 550 | 600 |  | 0.5 |  |  |  |  |  |  |  |  |  | 0.5
N-68 |  |  |  |  | 28.5 | 32 |  |  |  | 0.6 |  |  |  |  |  |  |  |  |  | 0.6
M-83 | 22 | 22.5 | 23 | 25 | 26.5 | 26 | 32 | 32 |  | 0.7 |  |  |  |  |  |  |  |  |  | 0.7
K-115 | 24.5 | 27.5 | 28 | 29.5 | 31.5 | 33.5 | 36.5 | 38.5 |  | 0.8 |  |  |  |  |  |  |  |  |  | 0.8
MB-135 |  | 27.5 | 27.5 | 29 | 30.5 | 30.5 | 36 | 39.5 |  | 0.9 |  |  |  |  |  |  |  |  |  | 0.9
MD-199 |  |  | 28.5 | 30.5 | 32.5 | 32.5 | 37.5 | 41 |  | 1 |  |  |  |  |  |  |  |  |  | 1
KD-199 |  |  | 32.5 | 34.5 | 36.5 | 39 | 42.5 | 44.5 |  | 1.1 |  |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  |  | 1.2
Double box sides - Pair
300 | 350 | 400 | 450 | 500 | 550 | 600
10 | 11 | 12.5 | 13.5 | 15 | 16 | 17.5 |  |  |  | [NAME] | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  | MB-40S-IN | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
 |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  |  | 0.3
Handle |  | 6 |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  |  | 0.4
[NAME] In | Pair | 2.5 |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  | 0.5
[NAME] | 1100mm | 21 |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  |  | 0.6
Cross Gal | 1100mm | 5.5 |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  |  | 0.7
Stabiliser set |  | 10 |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  |  | 0.8
U for plumbing |  | 10 |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  |  | 0.9
Vari back brac set |  | 3 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
Additional Gall set |  | 9 |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  |  | 1.1
Inner handle |  | 6 |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  |  | 1.2
Sync rod |  | 8
 |  |  |  |  |  |  |  |  |  | KD-40S | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  | MD-40S-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
 |  |  |  |  |  |  |  |  |  | MB-40S | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  | MDD-40S-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
 |  |  |  |  |  |  |  |  |  | MD-40S | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  | KD-40S-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
 |  |  |  |  |  |  |  |  |  | MDD-40S | 0.27 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6
 |  |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  |  | 0.8
 |  |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  | 1.2