Spreadsheet: 756568d1637644506-nested-ifs-error-examplenest-1-
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 940
 |  | 100 | 100 |  |  |  | 100 | 100 |  |  |  |  |  | 100 | 100 |  |  |  |  |  | 100 |  |  |  |  |  |  | 100 |  | 100 | 20 |  |  |  |  |  | 100 | 100 | 100 | 20 |  |  |  |  |  | 100 | 100 | 100 | 20 |  |  |  |  |  | 100 |  | 20 |  |  |  |  |  | 100 | 100 | 20 |  |  |  |  |  | 100 | 100 | 20 |  |  |  |  |  | 100 |  |  |  |  |  |  | 100 | 100 |  |  |  |  |  | 100 | 100 |  |  |  |  |  |  | 100 |  |  |  |  |  |  | 100 |  |  |  |  |  |  | 100
 |  | All |  |  |  |  | 1st |  |  |  |  |  |  | 1st |  |  |  |  |  |  | 1st |  |  |  |  |  |  | 2nd |  |  |  |  |  |  |  |  | 2nd |  |  |  |  |  |  |  |  | 2nd |  |  |  |  |  |  |  |  | 3rd |  |  |  |  |  |  |  | 3rd |  |  |  |  |  |  |  | 3rd |  |  |  |  |  |  |  | 4th |  |  |  |  |  |  | 4th |  |  |  |  |  |  | 4th |  |  |  |  |  |  | 5th |  |  |  |  |  |  | 5th |  |  |  |  |  |  | 5th
 |  |  |  |  |  |  | Fam |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Fam |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Fam |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Fam |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Fam |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Fam
ID | Set | Q | T | ST | SR |  | Q | T | ST | SR | LT | LR |  | Q | T | ST | SR | LT | LR |  | Q | T | ST | SR | LT | LR |  | Q | T | PP | W | S | S | LT | LR |  | Q | T | PP | W | S | S | LT | LR |  | Q | T | PP | W | S | S | LT | LR |  | Q | T | PP | W | S | S | LT | LR | Q | T | PP | W | S | S | LT |  | Q | T | PP | W | S | S | LT |  | Q | T | PP | W | S | S |  | Q | T | PP | W | S | S |  | Q | T | PP | W | S | S |  | Q | T | PP | W | S | S |  | Q | T | PP | W | S | S |  | Q | T | PP | W | S | S | LT | [NAME] |  | Q | T | ST | SR | LT | LR
 | AA | 90 | 100 | 190 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  | 80 | 3 | 270 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 40 | 59 |  | 199 | 6 | 469 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 46 | 20 | 166 | 3 | 635 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 100 | 150 | 3 | 785 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87 | 87 | 1 | 872 | 1
54321 | CG | 70 | 100 | 170 | 30 |  | 70 | 50 | 120 | 25 | 290 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 62 | 20 | 182 | 2 | 472 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 20 | 110 | 1 | 582 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  | 70 | 2 | 652 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81.5 | 81.5 | 3 | 733.5 | 3
15432 | CE | 90 | 95 | 185 | 8 |  | 85 | 100 | 185 | 1 | 370 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 48.66 | 20 | 168.66 | 5 | 538.66 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 100 | 3 | 638.66 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  | 70 | 2 | 708.66 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82 | 82 | 2 | 790.66 | 1
25431 | FA | 80 | 90 | 170 | 30 |  | 50 | 80 | 130 | 17 | 300 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 |  | 62 | 20 | 177 | 3 | 477 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 20 | 110 | 1 | 587 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  | 80 | 1 | 667 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80.5 | 80.5 | 4 | 747.5 | 2
35421 | OO | 80 | 95 | 175 | 25 |  |  |  |  |  |  |  |  | 80 | 50 | 130 | 82 | 305 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | 100 | 57.99 | 20 | 257.99 | 7 | 562.99 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 86.65 | 20 | 156.65 | 26 | 719.64 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 | 100 | 195 | 1 | 914.64 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 27 | 914.6365 | 8
45321 | RA | 80 | 70 | 150 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  | 80 | 3 | 230 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  | 73.66 |  | 133.66 | 17 | 363.66 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | 81.5 | 20 | 181.5 | 2 | 545.16 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 60 | 90 | 5 | 635.16 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 5 | 635.16 | 5
35214 | TG | 80 | 50 | 130 | 108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  | 80 | 3 | 210 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 88 | 62 |  | 250 | 2 | 460 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 58.5 |  | 158.5 | 4 | 618.5 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 100 | 170 | 1 | 788.5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80.5 | 80.5 | 3 | 869 | 2
25134 | CK | 80 | 100 | 180 | 12 |  |  |  |  |  |  |  |  | 100 | 98 | 198 | 4 | 378 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 | 100 | 59 |  | 244 | 15 | 622 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | 69.96 | 20 | 169.96 | 11 | 791.96 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 | 100 | 190 | 2 | 981.96 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87 | 87 | 1 | 1068.962 | 2