Spreadsheet: 774503d1648509679-how-to-filter-a-cell-dependant-on-3-other-cells-drawercosting
Sheet: ANT

[NAME] base |  |  |  |  |  |  |  |  | [NAME] cost N,M |  |  |  |  |  |  |  |  | Whiteboard cost K
Column1 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65 |  | Column1 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65 |  | Column1 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
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
[NAME] back | N,M | K | B,C,D |  |  |  |  |  | [NAME] cost B,C,D
Column1 | 0.084 | 0.116 | 0.2 |  |  |  |  |  | Column1 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
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
[NAME] 30 | 270 | 350 | 400 | 450 | 500 | 550 | 650
N |  |  | 50 | 50 | 50.5 | 54 |  |  | N-30 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
M | 49.5 | 49.5 | 50 | 50 | 50.5 | 54 |  |  | 0.3
B | 57.5 | 58 | 59 | 59 | 59.5 | 66.5 | 86.5 |  | 0.4
C | 58.5 | 59.5 | 60 | 60.5 | 60.5 | 64.5 |  |  | 0.5
M-D | 58.5 | 59.5 | 60 | 60.5 | 60.5 | 64.5 |  |  | 0.6
M-DD |  |  |  | 73.5 | 76.5 | 81 |  |  | 0.7
 |  |  |  |  |  |  |  |  | 0.8
[NAME] 65 | 270 | 350 | 400 | 450 | 500 | 550 | 650 |  | 0.9
M |  |  |  | 54.5 | 54.5 | 57.5 | 76.5 |  | 1
B |  |  |  | 63 | 63.5 | 66.5 | 86.5 |  | 1.1
C |  |  |  | 64.5 | 64.5 | 68 | 88 |  | 1.2
M-D |  |  |  | 64.5 | 64.5 | 68 | 88
M-DD |  |  |  | 78 | 80.5 | 84.5
 |  |  |  |  |  |  |  |  | M-30 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | M-65 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
Kits In 30 | 270 | 350 | 400 | 450 | 500 | 550 |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
M | 71.5 | 71.5 | 72 | 72 | 72.5 | 75.5 |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
C |  | 92 | 92.5 | 93 | 93 | 97 |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
M-D |  |  | 93 | 93 | 93.5 | 97 |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
M-DD |  |  | 108 | 111 | 115 | 115 |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
Kits In 65 | 450 | 500 | 550 | 650 |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
M | 80 | 80 | 80 | 100 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
C | 97 | 97 | 100.5 | 121 |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
C-D | 97 | 97.5 | 100.5 | 121 |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
M-DD | 112 | 115 | 119
 |  |  |  |  |  |  |  |  | B-30
[NAME] 65 | 650 Deep |  |  |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65 |  | C-65 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
M | 127 |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  | 0.3
C | 180 |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  |  | 0.4
M-D | 182 |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  |  | 0.6
Whiteboard |  | 35.5 | M2 |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  | 0.8
[NAME] | 1036[NAME] | 19 |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  | 0.9
Cross Gal | 1046mm | 9 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  |  | 1.1
[NAME] lock piece |  | 1 |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  | C-30
 |  |  |  |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | MD-65 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
 |  |  |  |  |  |  |  |  | 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-30
 |  |  |  |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | MDD-65 | 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
 |  |  |  |  |  |  |  |  | MDD-30 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | M-65-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
 |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  | M-30-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | C-65-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
 |  |  |  |  |  |  |  |  | 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-30-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | MD-65-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.65
 |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  | D-30-IN | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | MDD-65-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
 |  |  |  |  |  |  |  |  | MDD-30-IN | 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