Spreadsheet: 231725d1367208250-assign-two-values-to-cell-dependent-on-a-drop-down-menu-excel-problem-1
Sheet: 8bb (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | K | Q | J | T | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.02 | 0.03 | 0.06 | 0.09 | 0.11 | 0.11 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.02 | 0.07 | 0.09 | 0.13 | 0.18 | 0.22 | 0.23 | 0.24 | 0.24 | 0.26 | 0.29 | 0.29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.06 | 0.11 | 0.02 | 0.12 | 0.13 | 0.21 | 0.26 | 0.33 | 0.33 | 0.35 | 0.38 | 0.4 | 0.42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09 | 0.15 | 0.2 | 0.03 | 0.12 | 0.18 | 0.25 | 0.35 | 0.42 | 0.45 | 0.49 | 0.53 | 0.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.11 | 0.19 | 0.24 | 0.26 | 0.03 | 0.16 | 0.22 | 0.28 | 0.44 | 0.57 | OF/AF | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.13 | 0.24 | 0.32 | 0.36 | 0.36 | 0.04 | 0.21 | 0.26 | 0.37 | 0.56 | OF/AF | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.3 | 0.39 | 0.47 | 0.49 | 0.48 | 0.05 | 0.21 | 0.29 | 0.47 | 0.75 | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.31 | 0.45 | 0.54 | 0.59 | 0.63 | 0.62 | 0.07 | 0.25 | 0.36 | 0.68 | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.16 | 0.33 | 0.47 | 0.61 | 0.67 | OF/AF | OF/AF | OF/AF | 0.08 | 0.28 | 0.49 | 0.86 | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.16 | 0.36 | 0.5 | 0.62 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.09 | 0.35 | 0.68 | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.17 | 0.36 | 0.52 | 0.65 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.09 | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.17 | 0.38 | 0.55 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.09 | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.19 | 0.4 | 0.56 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.024 | 0.036 | 0.072 | 0.108 | 0.132 | 0.132 | 0.156 | 0.156 | 0.156 | 0.156 | 0.156 | 0.156
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.048 | 0.024 | 0.084 | 0.108 | 0.156 | 0.216 | 0.264 | 0.276 | 0.288 | 0.288 | 0.312 | 0.348 | 0.348
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.072 | 0.132 | 0.024 | 0.144 | 0.156 | 0.252 | 0.312 | 0.396 | 0.396 | 0.42 | 0.456 | 0.48 | 0.504
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.108 | 0.18 | 0.24 | 0.036 | 0.144 | 0.216 | 0.3 | 0.42 | 0.504 | 0.54 | 0.588 | 0.636 | 0.672
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.132 | 0.228 | 0.288 | 0.312 | 0.036 | 0.192 | 0.264 | 0.336 | 0.528 | 0.6839999999999999 | OF/AF | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.156 | 0.288 | 0.384 | 0.432 | 0.432 | 0.048 | 0.252 | 0.312 | 0.444 | 0.672 | OF/AF | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.18 | 0.36 | 0.468 | 0.564 | 0.588 | 0.576 | 0.06 | 0.252 | 0.348 | 0.564 | 0.8999999999999999 | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.18 | 0.372 | 0.54 | 0.648 | 0.708 | 0.756 | 0.744 | 0.084 | 0.3 | 0.432 | 0.8160000000000001 | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.192 | 0.396 | 0.564 | 0.732 | 0.804 | OF/AF | OF/AF | OF/AF | 0.096 | 0.336 | 0.588 | 1.032 | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.192 | 0.432 | 0.6 | 0.744 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.108 | 0.42 | 0.8160000000000001 | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.204 | 0.432 | 0.624 | 0.78 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.108 | OF/AF | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.204 | 0.456 | 0.66 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.108 | OF/AF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.228 | 0.48 | 0.672 | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | OF/AF | 0.12