Spreadsheet: 94480d1294278020-multiple-if-statements-sample-analysis
Sheet: Data

GENDER | Member Age | Plan Sub-Type | CO PAY | CAPAMT11 |  | [NAME] Payments
M | 5 | Pers | 15 | 38.23 |  | 38.22975
M | 40 | Pers | 15 | 70.18 |  | 70.18050000000001
F | 8 | Pers | 15 | 40.29 |  | 40.29675
F | 37 | Pers | 15 | 109.48 |  | 109.48275
F | 12 | Pers | 15 | 40.29 |  | 40.29675
F | 21 | Pers | 15 | 70.45 |  | 70.44375
F | 14 | Group | 25 | 38.31 |  | 38.31291
F | 45 | Pers | 15 | 123.75 |  | 123.747
F | 47 | Group | 25 | 117.66 |  | 117.65484
M | 54 | Pers | 15 | 113.97 |  | 113.96775
F | 24 | Group | 40 | 82.16 |  | 84.06615
M | 36 | Group | 20 | 56.14 |  | 56.1355
M | 34 | Group | 20 | 47.65 |  | 47.65199999999999
F | 34 | Group | 20 | 109.73 |  | 109.7345
F | 53 | Group | 15 | 145.02 |  | 145.0215
M | 12 | HEALTHY FAMILIES | 5 | 29.95 |  | #N/A
F | 1 | Pers | 15 | 0 |  | 106.158
F | 13 | HEALTHY FAMILIES | 5 | 0 |  | #N/A
M | 41 | Pers | 15 | 70.18 |  | 70.18050000000001
M | 45 | Group | 10 | 89.64 |  | 89.63712
M | 12 | Group | 30 | 30.44 |  | 30.70126
M | 34 | Group | 30 | 45.45 |  | 45.84624
F | 15 | HEALTHY FAMILIES | 5 | 0 |  | #N/A
M | 9 | Pers | 15 | 32.75 |  | 32.75025
M | 4 | Pers | 15 | 38.23 |  | 38.22975
M | 34 | Group | 10 | 50.36 |  | 50.36064
F | 24 | Group | 20 | 90.24 |  | 90.2405
F | 24 | Group | 20 | 90.24 |  | 90.2405
F | 29 | Group | 15 | -115.31 |  | 115.31325
M | 60 | Group | 20 | 184.67 |  | 184.6705
F | 54 | Pers | 15 | 145.02 |  | 145.0215
M | 1 | HEALTHY FAMILIES | 10 | 29.95 |  | #N/A
F | 12 | HEALTHY FAMILIES | 10 | 29.95 |  | #N/A
M | 8 | Pers | 15 | 32.75 |  | 32.75025
M | 14 | POS | 10 | 29.14 |  | #N/A
F | 31 | POS | 10 | 100.2 |  | #N/A
F | 33 | POS | 10 | 100.2 |  | #N/A
F | 73 | POS | 10 | 45.27 |  | #N/A
F | 10 | POS | 10 | 35.85 |  | #N/A
M | 3 | POS | 10 | 34.01 |  | #N/A
M | 8 | POS | 10 | 29.14 |  | #N/A
F | 36 | POS | 10 | 97.4 |  | #N/A
M | 6 | POS | 10 | 34.01 |  | #N/A
M | 37 | POS | 10 | 51.26 |  | #N/A
F | 34 | POS | 10 | 100.2 |  | #N/A
F | 43 | POS | 10 | 99.56 |  | #N/A
F | 13 | POS | 10 | 35.85 |  | #N/A
F | 58 | POS | 25 | 135.78 |  | #N/A
M | 64 | POS | 10 | 168.62 |  | #N/A
F | 58 | POS | 10 | 147.06 |  | #N/A
M | 35 | POS | 10 | 51.26 |  | #N/A
F | 57 | POS | 10 | 147.06 |  | #N/A
M | 55 | POS | 10 | 133.89 |  | #N/A
F | 9 | POS | 10 | 35.85 |  | #N/A
F | 55 | POS | 15 | 142.81 |  | #N/A
F | 24 | POS | 10 | 82.39 |  | #N/A
M | 5 | POS | 10 | 34.01 |  | #N/A
F | 13 | POS | 10 | 35.85 |  | #N/A
M | 0 | POS | 10 | 94.45 |  | #N/A
M | 34 | POS | 10 | 43.51 |  | #N/A
F | 34 | POS | 10 | 100.2 |  | #N/A
F | 10 | POS | 10 | 35.85 |  | #N/A
M | 8 | POS | 10 | 29.14 |  | #N/A
F | 35 | POS | 10 | 97.4 |  | #N/A
F | 20 | POS | 10 | 62.67 |  | #N/A
F | 31 | POS | 10 | 100.2 |  | #N/A
M | 35 | POS | 10 | 51.26 |  | #N/A
F | 28 | POS | 10 | 102.59 |  | #N/A
M | 37 | POS | 10 | 51.26 |  | #N/A
F | 0 | POS | 10 | 94.45 |  | #N/A
F | 34 | POS | 10 | 100.2 |  | #N/A
F | 4 | POS | 10 | 34.01 |  | #N/A
M | 46 | POS | 10 | 77.44 |  | #N/A
M | 2 | POS | 10 | 34.01 |  | #N/A
M | 2 | POS | 10 | 34.01 |  | #N/A
F | 6 | POS | 10 | 34.01 |  | #N/A
M | 36 | POS | 10 | 51.26 |  | #N/A
F | 37 | POS | 10 | 97.4 |  | #N/A
F | 0 | POS | 10 | 94.45 |  | #N/A
M | 31 | POS | 10 | 43.51 |  | #N/A
F | 44 | POS | 10 | 99.56 |  | #N/A
M | 12 | POS | 10 | 29.14 |  | #N/A
M | 14 | POS | 10 | 29.14 |  | #N/A
M | 15 | POS | 10 | 29.14 |  | #N/A
M | 0 | POS | 10 | 94.45 |  | #N/A
M | 42 | Group | 10 | 72.26 |  | 72.26792
F | 29 | Group | 20 | 95.5 |  | 112.3565
M | 8 | HEALTHY FAMILIES | 10 | 29.95 |  | #N/A
F | 2 | Pers | 15 | 38.23 |  | 38.22975
F | 2 | Pers | 15 | 0 |  | 38.22975
M | 1 | Group | 25 | 100.93 |  | 100.93176
F | 20 | Pers | 15 | 70.45 |  | 70.44375
F | 39 | Pers | 15 | 109.48 |  | 109.48275
M | 1 | Pers | 15 | 106.16 |  | 106.158
F | 33 | Group | 30 | 104.65 |  | 105.57614
M | 22 | Pers | 15 | 34.91 |  | 34.90499999999999
F | 40 | Pers | 15 | 111.9 |  | 111.90075
M | 9 | HEALTHY FAMILIES | 5 | 0
M | 19 | Pers | 15 | 34.37