Spreadsheet: 758440d1638880051-nested-if-different-criteria-each-with-different-outcomes-book1
Sheet: SAMPLE

 |  |  |  |  |  |  |  |  |  |  | FINAL VERSION | FINAL VERSION | FINAL VERSION | FINAL VERSION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA WORKINGS
Actuals: |  |  |  |  |  |  |  |  |  |  | FORMULA HERE | FORMULA HERE | FORMULA HERE | FORMULA HERE | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 1 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | SYSTEM 2 | EXPECTED | FORMULA | CHECK | EXPECTED | FORMULA | CHECK | EXPECTED | FORMULA | CHECK | EXPECTED | FORMULA | CHECK
 |  | not in sample | Market | Category | Subcategory | not in sample | not in sample | not in sample | Format | SKU | Weight | Flavour | Strength | Colour | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | System 1:  Chew Weight | System 1: Meal prep kit weight | System 1:  Modern category Flavor | System 1:  Meat kit Flavor | System 1:  Meal prep kit Flavor 1 | System 1:  Meal prep kit Flavor 2 | System 1:  Modern category strength | System 1:  Meal prep kit strength | System 1:  Colour | System 1:  [NAME] | System 1:  [NAME] | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | not in sample | System 2:  Chew weight | System 2:  Meal prep kit weight | System 2:  Modern category Flavor | System 2:  Meat kit flavour | System 2:  Meal prep kit Flavor 1 | System 2:  Meal prep kit Flavor 2 | System 2:  Modern category strength | System 2:  Meal prep kit strength | System 2:  Colour | System 2:  [NAME] | System 2:  [NAME] | Weight | Weight | Weight | Flavour | Flavour | Flavour | Strength | Strength | Strength | Colour | Colour | Colour
 |  |  | Germany | Modern category | Chew |  |  |  | Consumable | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 5
 |  |  | Germany | Meat kit | Meat |  |  |  | Consumable | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Blue | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 2 | #N/A | #N/A | #N/A |  |  |  |  |  |  | 2 |  |  | Blue
 |  |  | Germany | Meat kit | Meat |  |  |  | Not consumable | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Purple | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | Blueberry | #N/A | #N/A | #N/A | #N/A | 1 | #N/A | #N/A | #N/A |  |  |  | Blueberry |  |  | 1 |  |  | Purple
 |  |  | Germany | Meal prep kit | Open |  |  |  | Consumable | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | Germany | Meal prep kit | Open |  |  |  | Consumable | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Consumable | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Not consumable | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | Germany | Modern category | Chew |  |  |  | Consumable | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 7 - Blueberry |  |  |  | 4 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | # | Blueberry | Not assigned | Not assigned | Not assigned | 4 | # | Not assigned | White | Not assigned | 2 |  |  | 7 - Blueberry |  |  | 4 |  |  | White
 |  |  | Germany | Modern category | Chew |  |  |  | Consumable | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 13 - Freeze Peppermint |  |  |  | 10.9 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - | # | [NAME] | Not assigned | Not assigned | Not assigned | 10.9 | # | Not assigned | White | Not assigned |  |  |  | 13 - Freeze Peppermint |  |  | 10.9 |  |  | White
 |  |  | Germany | Modern category | Chew |  |  |  | Consumable | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | Not assigned | Not assigned | # | # | Not assigned | White | Not assigned |  |  |  |  |  |  |  |  |  | White
 |  |  | Germany | Modern category | Chew |  |  |  | Consumable | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | Not assigned | Not assigned | # | # | Not assigned | White | Not assigned |  |  |  |  |  |  |  |  |  | White
 |  |  | Germany | Modern category | Chew |  |  |  | Consumable | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | # | Not assigned | Not assigned | Not assigned | Not assigned | # | 7 | Not assigned | White | Not assigned | 1 |  |  |  |  |  | 7 |  |  | White
 |  |  | Germany | Meat kit | Meat |  |  |  | Consumable | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Other Flavour |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Other Flavour | Not assigned | Not assigned | # | 14 | Not assigned | Not assigned | Not assigned |  |  |  | Other Flavour |  |  | 14
 |  |  | Germany | Meat kit | Meat |  |  |  | Consumable | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Other Flavour |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Other Flavour | Not assigned | Not assigned | # | # | Not assigned | Not assigned | Not assigned |  |  |  | Other Flavour
 |  |  | Germany | Meat kit | Meat |  |  |  | Not consumable | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | BE - Blue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | Not assigned | Not assigned | # | # | Not assigned | Not assigned | Blue |  |  |  |  |  |  |  |  |  | BE - Blue
 |  |  | Germany | Meat kit | Meat |  |  |  | Not consumable | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | WH - White |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | Not assigned | Not assigned | # | # | Not assigned | Not assigned | White |  |  |  |  |  |  |  |  |  | WH - White
 |  |  | Germany | Meal prep kit | Open |  |  |  | Consumable | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10.00 |  |  |  |  |  | 12 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | 10.00 | Not assigned | Not assigned | Not assigned | Not assigned | # | 12 | Not assigned | Not assigned | Not assigned | 10 |  |  |  |  |  | 12
 |  |  | Germany | Meal prep kit | Open |  |  |  | Not consumable | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 12 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | Not assigned | Not assigned | # | 12 | Not assigned | Not assigned | Not assigned |  |  |  |  |  |  | 12
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Not consumable | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | MP - Mixed Pack | MP - Mixed Pack |  | 12 |  | 0 | GB - Graphite Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | [NAME] | [NAME] | # | 12 | Graphite Black | Not assigned | Graphite Black |  |  |  | MP - Mixed Pack |  |  | 12 |  |  | GB - Graphite Black
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Not consumable | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | MP - Mixed Pack | MP - Mixed Pack |  | 12 |  | 0 | GB - Graphite Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | [NAME] | [NAME] | # | 12 | Graphite Black | Not assigned | Graphite Black |  |  |  | MP - Mixed Pack |  |  | 12 |  |  | GB - Graphite Black
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Not consumable | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | NF - No Flavour | NF - No Flavour |  | 0 |  | 0 | GB - Graphite Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | 3 | Not assigned | Not assigned | No Flavour | No Flavour | # | 0 | Graphite Black | Not assigned | Graphite Black | 3 |  |  | NF - No Flavour |  |  | 0 |  |  | GB - Graphite Black
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Not consumable | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | NF - No Flavour | NF - No Flavour |  | 0 |  | 0 | SL - Silver |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | No Flavour | No Flavour | # | 0 | Silver | Not assigned | Silver |  |  |  | NF - No Flavour |  |  | 0 |  |  | SL - Silver
 |  |  | Germany | Meal prep kit | Open |  |  |  | Not consumable | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | NF - No Flavour | NF - No Flavour |  | 0 |  | 0 | BL - Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | No Flavour | No Flavour | # | 0 | Black | Not assigned | Black |  |  |  | NF - No Flavour |  |  | 0 |  |  | BL - Black
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Not consumable | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | LU - Blushed Mango | LU - Blushed Mango |  | 18 |  | 0 | GP - Graphite |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | Blushed Mango | Blushed Mango | # | 18 | Graphite | Not assigned | Graphite |  |  |  | LU - Blushed Mango |  |  | 18 |  |  | GP - Graphite
 |  |  | Germany | Meal prep kit | Closed |  |  |  | Not consumable | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | LU - Blushed Mango | LU - Blushed Mango |  | 18 |  | 0 | GP - Graphite |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | Blushed Mango | Blushed Mango | # | 18 | Graphite | Not assigned | Graphite |  |  |  | LU - Blushed Mango |  |  | 18 |  |  | GP - Graphite
 |  |  | Germany | Meal prep kit | Open |  |  |  | Not consumable | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | NF - No Flavour | NF - No Flavour |  | 0 |  | 0 | BL - Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | # | Not assigned | Not assigned | No Flavour | No Flavour | # | 0 | Black | Not assigned | Black |  |  |  | NF - No Flavour |  |  | 0 |  |  | BL - Black