Spreadsheet: 756552d1637624278-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]
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]
12345 | 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 |  | if(and(vlookup(A11,'Group Info'!$A$14:$D$1026,4,0)=$CW$8),(C11>0,D11>0,H11>0,I11>0,AC11>0,AE11>0,AF11>0,BD11>0,BF11>0,CB11>0,CX11>0)),"Yes",if(and((vlookup(A11,'Group Info'!$A$14:$D$1026,4,0)=$DD$8),(C11>0,D11>0,O11>0,P11>0,AL11>0,AM11>0,AN11>0,AO11>0,BL11>0,BM11>0,BN11>0,CI11>0,CJ11>0,DE11>0),"Yes",if(and((vlookup(A11,'Group Info'!$A$14:$D$1026,4,0)=$dk$8,(C11>0,D11>0,V11>0,AU11>0,AV11>0,AW11>0,AX11>0,BT11>0,BU11>0,BV11>0,CP11>0,CQ11>0,DL11>0),"Yes","")))))
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
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 |  |  |  |  |  |  |  |  | #[NAME]!
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 |  | #[NAME]!
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 |  | #[NAME]!
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