Spreadsheet: 456910d1461115841-nested-if-function-not-functioning-correctly-excel-if-help
Sheet: Practice

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
Pit |  |  |  |  |  |  |  |  | Strip
N2 |  |  |  |  |  |  |  |  | 15
N2 |  |  |  |  |  |  |  |  | 15
N2 |  |  |  |  |  |  |  |  | 15
N1S |  |  |  |  |  |  |  |  | 39
N1S |  |  |  |  |  |  |  |  | 39
N1S |  |  |  |  |  |  |  |  | 39
N1N |  |  |  |  |  |  |  |  | 39
N1N |  |  |  |  |  |  |  |  | 39
N1N |  |  |  |  |  |  |  |  | 39
N1N |  |  |  |  |  |  |  |  | 39
N1N |  |  |  |  |  |  |  |  | 39
N1N |  |  |  |  |  |  |  |  | 39
N2 |  |  |  |  |  |  |  |  | 16
N2 |  |  |  |  |  |  |  |  | 16
N2 |  |  |  |  |  |  |  |  | 16
N1S |  |  |  |  |  |  |  |  | 40DL
N1S |  |  |  |  |  |  |  |  | 40DL
N1S |  |  |  |  |  |  |  |  | 40DL
N1N |  |  |  |  |  |  |  |  | 40DL
N1N |  |  |  |  |  |  |  |  | 40DL
N1N |  |  |  |  |  |  |  |  | 40DL
Date |  | Product Produced | Start | End | Product Produced | Days to Produce | Produced/Day | Product Produced AUTO | Product Produced
 | Day code | ([NAME] t) |  |  |  |  |  | ([NAME] t)
 |  |  |  |  |  |  |  |  | 1.059
2016-03-01 00:00:00 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 30000 | 2 | 15000
 |  | 15000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 1 | 0 | 46000 | 3 | 15333.33333333333
 |  | 15000 | 0 | 0 | 0
 |  | 15000 | 0 | 1 | 0
 |  | 16000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 1 | 0 | 15000 | 2 | 7500
 |  | 15000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 5000 | 2 | 1 | 40000 | 2 | 20000
 |  | 15000 | 0 | 1 | 0
 |  | 15000 | 0 | 0 | 0
 |  | 4000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 34000 | 2 | 17000
 |  | 15000 | 0 | 1 | 0
 |  | 4000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 37000 | 3 | 12333.33333333333
 |  | 15000 | 0 | 0 | 0
 |  | 7000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 32000 | 3 | 10666.66666666667
 |  | 15000 | 0 | 0 | 0
 |  | 2000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 32000 | 3 | 10666.66666666667
 |  | 15000 | 0 | 0 | 0
 |  | 2000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 32000 | 3 | 10666.66666666667
 |  | 15000 | 0 | 0 | 0
 |  | 2000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 1 | 0 | 20800 | 3 | 6933.333333333333
 |  | 10800 | 0 | 0 | 0
 |  | 10000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 20000 | 2 | 10000
 |  | 5000 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 15000 | 1 | 0 | 21600 | 2 | 10800
 |  | 5160 | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 1 | 0 | 50000 | 3 | 16666.66666666667
 |  | 17000 | 0 | 0 | 0
 |  | 17000 | 0 | 1 | 0
 |  | 16000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 17000 | 1 | 0 | 55000 | 3 | 18333.33333333333
 |  | 17000 | 0 | 0 | 0
 |  | 16000 | 0 | 1 | 0
 |  | 5000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 17000 | 1 | 0 | 55000 | 3 | 18333.33333333333
 |  | 17000 | 0 | 0 | 0
 |  | 16000 | 0 | 1 | 0
 |  | 5000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 17000 | 1 | 0 | 55000 | 3 | 18333.33333333333
 |  | 17000 | 0 | 0 | 0
 |  | 16000 | 0 | 1 | 0
 |  | 5000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 17000 | 1 | 0 | 55000 | 3 | 18333.33333333333
 |  | 17000 | 0 | 0 | 0
 |  | 16000 | 0 | 1 | 0
 |  | 5000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 17000 | 1 | 0 | 55000 | 3 | 18333.33333333333
 |  | 17000 | 0 | 0 | 0
 |  | 16000 | 0 | 1 | 0
 |  | 5000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 16000 | 1 | 0 | 59000 | 3 | 19666.66666666667
 |  | 16000 | 0 | 0 | 0
 |  | 16000 | 0 | 1 | 0
 |  | 11000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  | 16000 | 1 | 0 | 60000 | 2 | 30000
 |  | 16000 | 0 | 1 | 0
 |  | 16000 | 0 | 0 | 0
 |  | 12000 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 1 | 0 | 21700 | 2 | 10850
 |  |  | 0 | 1 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0