Spreadsheet: 774539d1648539378-how-to-filter-a-cell-dependant-on-3-other-cells-drawercostingn
Sheet: Dragon

[NAME] base |  |  |  |  |  |  |  |  |  | [NAME] cost N,M |  |  |  |  |  |  |  |  | Whiteboard cost K |  |  |  |  |  |  |  |  | [NAME] cost C,F
 | 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.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
 |  |  |  |  |  |  |  |  |  | N_40D |  |  |  |  |  |  |  |  | M_40D_IN
[NAME] back |  |  |  |  |  |  |  |  |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600 |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600
 | N,M | K | C,F |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  | 300
Column1 | 0.095 | 0.13 | 0.24 |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  |  | 400
0.3 |  |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
0.4 |  |  |  |  |  |  |  |  |  | 600 |  |  |  |  |  |  |  |  | 600
0.5 |  |  |  |  |  |  |  |  |  | 700 |  |  |  |  |  |  |  |  | 700
0.6 |  |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  |  | 800
0.7 |  |  |  |  |  |  |  |  |  | 900 |  |  |  |  |  |  |  |  | 900
0.8 |  |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 1000
0.9 |  |  |  |  |  |  |  |  |  | 1100 |  |  |  |  |  |  |  |  | 1100
1 |  |  |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  |  |  | 1200
1.1
1.2 |  |  |  |  |  |  |  |  |  | M_40D |  |  |  |  |  |  |  |  | K_40D_IN
 |  |  |  |  |  |  |  |  |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600 |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600
Whiteboard |  | 35.5 | M2 |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  |  | 400
Dr Kits | 0.3 | 350 | 400 | 450 | 500 | 550 | 600 | Inners |  | 500 |  |  |  |  |  |  |  |  | 500
N-80 |  |  |  |  | 35.5 |  |  |  |  | 600 |  |  |  |  |  |  |  |  | 600
M-95 | 25 | 31.5 | 31.5 | 32.5 | 33 | 38 | 39 |  |  | 700 |  |  |  |  |  |  |  |  | 700
K-127 | 26.5 | 34 | 34.5 | 35 | 35.5 | 43.5 | 44 |  |  | 800 |  |  |  |  |  |  |  |  | 800
C-178 | 43.5 | 44.5 | 45 | 46 | 46.5 | 57 | 58 |  |  | 900 |  |  |  |  |  |  |  |  | 900
F-238 | 57 | 58.5 | 60 | 65.5 | 70.5 | 70.5 | 71.5 |  |  | 1000 |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  | 1100 |  |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  |  | K_40D |  |  |  |  |  |  |  |  | C_40D_IN
 |  |  |  |  |  |  |  |  |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600 |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600
Back Brac |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  | 300
N | 2.5 | ea |  |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  |  | 400
M | 2 | ea |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
K | 2.2 | ea |  |  |  |  |  |  |  | 600 |  |  |  |  |  |  |  |  | 600
C | 2.5 | ea |  |  |  |  |  |  |  | 700 |  |  |  |  |  |  |  |  | 700
F | 5 | ea |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  |  | 900 |  |  |  |  |  |  |  |  | 900
In [NAME] |  |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 1000
M | 3 | Pr |  |  |  |  |  |  |  | 1100 |  |  |  |  |  |  |  |  | 1100
K | 4.5 | Pr |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  |  |  | 1200
C | 6 | Pr
 |  |  |  |  |  |  |  |  |  | C_40D
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600
N | 2 | ea |  |  |  |  |  |  |  | 300
M | 2 | ea |  |  |  |  |  |  |  | 400
K | 2 | ea |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  |  | 700
[NAME] | 1043mm | 23 | ea |  |  |  |  |  |  | 800
Cross Gal | 1100mm | 6 | ea |  |  |  |  |  |  | 900
Side Stab |  | 2.5 | set |  |  |  |  |  |  | 1000
Gallery set |  | 9 | pr |  |  |  |  |  |  | 1100
Vary rear rail brac |  | 2.5 | pr |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  |  | F_40D
 |  |  |  |  |  |  |  |  |  | [NAME] | 300 | 350 | 400 | 450 | 500 | 550 | 600
 |  |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  |  | 1200