Spreadsheet: 708195d1607667094-if-and-ifs-help-please-automation-apprenticeeligibilitymaster
Sheet: App Eligibility

EligibilityName | YearOfApprenticeship | Duration | StartedApprenticeshipBefore1January2014 | StartedApprenticeshipBefore1January2015 | CompletedYear12 | YearCompleted | 21YearsOfAgeOrOverAtTheStartOfApprenticeship | EmployeeAge
1st year Before 1 Jan 2014 Not 21 | 1st year |  | True |  |  |  | False
2nd year Before 1 Jan 2014 Not 21 | 2nd year |  | True |  |  |  | False
3rd year Before 1 Jan 2014 Not 21 | 3rd year |  | True |  |  |  | False |  |  | Column Name | Column Reference | Output
4th year Before 1 Jan 2014 Not 21 | 4th year |  | True |  |  |  | False |  |  | Eligibility Name | A | FORMULA RESULT
1st year After 1 Jan 2014 Not year 12 Not 21 | 1st year |  | False |  | False |  | False |  |  | YearOfApprenticeship | B | Will display entered text
2nd year After 1 Jan 2014 Not year 12 Not 21 | 2nd year |  | False |  | False |  | False |  |  | Duration | C | Will display entered text
3rd year After 1 Jan 2014 Not year 12 Not 21 | 3rd year |  | False |  | False |  | False |  |  | StartedApprenticeshipBefore1January2014 | D | Before 1 Jan 2014
4th year After 1 Jan 2014 Not year 12 Not 21 | 4th year |  | False |  | False |  | False |  |  |  |  | After 1 Jan 2014
1st year After 1 Jan 2014 Year 12 Not 21 | 1st year |  | False |  | True |  | False |  |  | StartedApprenticeshipBefore1January2015 | E | Before 1 Jan 2015
2nd year After 1 Jan 2014 Year 12 Not 21 | 2nd year |  | False |  | True |  | False |  |  |  |  | After 1 Jan 2015
3rd year After 1 Jan 2014 Year 12 Not 21 | 3rd year |  | False |  | True |  | False |  |  | CompletedYear12 | F | Year 12
4th year After 1 Jan 2014 Year 12 Not 21 | 4th year |  | False |  | True |  | False |  |  |  |  | Not Year 12
1st year Before 1 Jan 2014 21 | 1st year |  | True |  |  |  | True |  |  | YearCompleted | G | Will display entered text
2nd year Before 1 Jan 2014 21 | 2nd year |  | True |  |  |  | True |  |  | 21YearsOfAgeOrOverAtTheStartOfApprenticeship | H | 21
3rd year Before 1 Jan 2014 21 | 3rd year |  | True |  |  |  | True |  |  |  |  | Not 21
4th year Before 1 Jan 2014 21 | 4th year |  | True |  |  |  | True |  |  | EmployeeAge | I | Will display entered text
1st year/stage 1 Before 1 Jan 2014 Not 21 | Apprentice 1st year / Stage 1 |  | True |  |  |  | False
2nd year/stage 2 Before 1 Jan 2014 Not 21 | Apprentice 2nd year / Stage 2 |  | True |  |  |  | False
3rd year/stage 3 Before 1 Jan 2014 Not 21 | Apprentice 3rd year / Stage 3 |  | True |  |  |  | False
4th year/stage 4 Before 1 Jan 2014 Not 21 | Apprentice 4th year / Stage 4 |  | True |  |  |  | False
1st year/stage 1 After 1 Jan 2014 Not year 12 Not 21 | Apprentice 1st year / Stage 1 |  | False |  | False |  | False
2nd year/stage 2 After 1 Jan 2014 Not year 12 Not 21 | Apprentice 2nd year / Stage 2 |  | False |  | False |  | False
3rd year/stage 3 After 1 Jan 2014 Not year 12 Not 21 | Apprentice 3rd year / Stage 3 |  | False |  | False |  | False
4th year/stage 4 After 1 Jan 2014 Not year 12 Not 21 | Apprentice 4th year / Stage 4 |  | False |  | False |  | False
1st year/stage 1 After 1 Jan 2014 Year 12 Not 21 | Apprentice 1st year / Stage 1 |  | False |  | True |  | False
2nd year/stage 2 After 1 Jan 2014 Year 12 Not 21 | Apprentice 2nd year / Stage 2 |  | False |  | True |  | False
3rd year/stage 3 After 1 Jan 2014 Year 12 Not 21 | Apprentice 3rd year / Stage 3 |  | False |  | True |  | False
4th year/stage 4 After 1 Jan 2014 Year 12 Not 21 | Apprentice 4th year / Stage 4 |  | False |  | True |  | False
1st year/stage 1 Before 1 Jan 2014 21 | Apprentice 1st year / Stage 1 |  | True |  |  |  | True
2nd year/stage 2 Before 1 Jan 2014 21 | Apprentice 2nd year / Stage 2 |  | True |  |  |  | True
3rd year/stage 3 Before 1 Jan 2014 21 | Apprentice 3rd year / Stage 3 |  | True |  |  |  | True
4th year/stage 4 Before 1 Jan 2014 21 | Apprentice 4th year / Stage 4 |  | True |  |  |  | True
1st year/stage 1 After 1 Jan 2014 21 | Apprentice 1st year / Stage 1 |  | False |  |  |  | True
2nd year/stage 2 After 1 Jan 2014 21 | Apprentice 2nd year / Stage 2 |  | False |  |  |  | True
3rd year/stage 3 After 1 Jan 2014 21 | Apprentice 3rd year / Stage 3 |  | False |  |  |  | True
4th year/stage 4 After 1 Jan 2014 21 | Apprentice 4th year / Stage 4 |  | False |  |  |  | True
1st year Before 1 Jan 2014 | 1st year |  | True
2nd year Before 1 Jan 2014 | 2nd year |  | True
3rd year Before 1 Jan 2014 | 3rd year |  | True
4th year Before 1 Jan 2014 | 4th year |  | True
1st year 4 years Before 1 Jan 2014 Not 21 | 1st year | 4 years | True |  |  |  | False
2nd year 4 years Before 1 Jan 2014 Not 21 | 2nd year | 4 years | True |  |  |  | False
3rd year 4 years Before 1 Jan 2014 Not 21 | 3rd year | 4 years | True |  |  |  | False
4th year 4 years Before 1 Jan 2014 Not 21 | 4th year | 4 years | True |  |  |  | False
1st year 4 years After 1 Jan 2014 Not year 12 Not 21 | 1st year | 4 years | False |  | False |  | False
2nd year 4 years After 1 Jan 2014 Not year 12 Not 21 | 2nd year | 4 years | False |  | False |  | False
3rd year 4 years After 1 Jan 2014 Not year 12 Not 21 | 3rd year | 4 years | False |  | False |  | False
4th year 4 years After 1 Jan 2014 Not year 12 Not 21 | 4th year | 4 years | False |  | False |  | False
1st year 4 years After 1 Jan 2014 Year 12 Not 21 | 1st year | 4 years | False |  | True |  | False
2nd year 4 years After 1 Jan 2014 Year 12 Not 21 | 2nd year | 4 years | False |  | True |  | False
3rd year 4 years After 1 Jan 2014 Year 12 Not 21 | 3rd year | 4 years | False |  | True |  | False
4th year 4 years After 1 Jan 2014 Year 12 Not 21 | 4th year | 4 years | False |  | True |  | False
1st year 3 years Before 1 Jan 2014 Not 21 | 1st year | 3 years | True |  |  |  | False
2nd year 3 years Before 1 Jan 2014 Not 21 | 2nd year | 3 years | True |  |  |  | False
3rd year 3 years Before 1 Jan 2014 Not 21 | 3rd year | 3 years | True |  |  |  | False
1st year 3 years After 1 Jan 2014 Not year 12 Not 21 | 1st year | 3 years | False |  | False |  | False
2nd year 3 years After 1 Jan 2014 Not year 12 Not 21 | 2nd year | 3 years | False |  | False |  | False
3rd year 3 years After 1 Jan 2014 Not year 12 Not 21 | 3rd year | 3 years | False |  | False |  | False
1st year 3 years After 1 Jan 2014 Year 12 Not 21 | 1st year | 3 years | False |  | True |  | False
2nd year 3 years After 1 Jan 2014 Year 12 Not 21 | 2nd year | 3 years | False |  | True |  | False
3rd year 3 years After 1 Jan 2014 Year 12 Not 21 | 3rd year | 3 years | False |  | True |  | False
1st year 21 | 1st year |  |  |  |  |  | True
2nd year 21 | 2nd year |  |  |  |  |  | True
3rd year 21 | 3rd year |  |  |  |  |  | True
4th year 21 | 4th year |  |  |  |  |  | True
1st year Not year 12 Not 21 | 1st year |  |  |  | False |  | False
2nd year Not year 12 Not 21 | 2nd year |  |  |  | False |  | False
3rd year Not year 12 Not 21 | 3rd year |  |  |  | False |  | False
4th year Not year 12 Not 21 | 4th year |  |  |  | False |  | False
1st year Before 1 Jan 2015 Year 12 Not 21 | 1st year |  |  | True | True |  | False
2nd year Before 1 Jan 2015 Year 12 Not 21 | 2nd year |  |  | True | True |  | False
3rd year Before 1 Jan 2015 Year 12 Not 21 | 3rd year |  |  | True | True |  | False
4th year Before 1 Jan 2015 Year 12 Not 21 | 4th year |  |  | True | True |  | False
1st year After 1 Jan 2015 Not 21 | 1st year |  |  | False | False |  | False
2nd year After 1 Jan 2015 Not 21 | 2nd year |  |  | False | False |  | False
3rd year After 1 Jan 2015 Not 21 | 3rd year |  |  | False | False |  | False
4th year After 1 Jan 2015 Not 21 | 4th year |  |  | False | False |  | False
1st year After 1 Jan 2014 21 | 1st year |  | False |  |  |  | True
2nd year After 1 Jan 2014 21 | 2nd year |  | False |  |  |  | True
3rd year After 1 Jan 2014 21 | 3rd year |  | False |  |  |  | True
4th year After 1 Jan 2014 21 | 4th year |  | False |  |  |  | True
1st year/stage 1 Before 1 Jan 2014 | Apprentice 1st year / Stage 1 |  | True
2nd year/stage 2 Before 1 Jan 2014 | Apprentice 2nd year / Stage 2 |  | True
3rd year/stage 3 Before 1 Jan 2014 | Apprentice 3rd year / Stage 3 |  | True
4th year/stage 4 Before 1 Jan 2014 | Apprentice 4th year / Stage 4 |  | True
1st year Before 1 Jan 2014 Under 18 years | 1st year |  | True |  |  |  |  | Under 18 years
2nd year Before 1 Jan 2014 Under 18 years | 2nd year |  | True |  |  |  |  | Under 18 years
3rd year Before 1 Jan 2014 Under 18 years | 3rd year |  | True |  |  |  |  | Under 18 years
4th year Before 1 Jan 2014 Under 18 years | 4th year |  | True |  |  |  |  | Under 18 years
1st year Before 1 Jan 2014 18 years | 1st year |  | True |  |  |  |  | 18 years
2nd year Before 1 Jan 2014 18 years | 2nd year |  | True |  |  |  |  | 18 years
3rd year Before 1 Jan 2014 18 years | 3rd year |  | True |  |  |  |  | 18 years
4th year Before 1 Jan 2014 18 years | 4th year |  | True |  |  |  |  | 18 years
1st year Before 1 Jan 2014 19 years | 1st year |  | True |  |  |  |  | 19 years
2nd year Before 1 Jan 2014 19 years | 2nd year |  | True |  |  |  |  | 19 years
3rd year Before 1 Jan 2014 19 years | 3rd year |  | True |  |  |  |  | 19 years
4th year Before 1 Jan 2014 19 years | 4th year |  | True |  |  |  |  | 19 years
1st year Before 1 Jan 2014 20 years | 1st year |  | True |  |  |  |  | 20 years
2nd year Before 1 Jan 2014 20 years | 2nd year |  | True |  |  |  |  | 20 years
3rd year Before 1 Jan 2014 20 years | 3rd year |  | True |  |  |  |  | 20 years
4th year Before 1 Jan 2014 20 years | 4th year |  | True |  |  |  |  | 20 years
1st year After 1 Jan 2014 Not year 12 Under 18 | 1st year |  | False |  | False |  |  | Under 18 years
2nd year After 1 Jan 2014 Not year 12 Under 18 | 2nd year |  | False |  | False |  |  | Under 18 years
3rd year After 1 Jan 2014 Not year 12 Under 18 | 3rd year |  | False |  | False |  |  | Under 18 years
4th year After 1 Jan 2014 Not year 12 Under 18 | 4th year |  | False |  | False |  |  | Under 18 years
1st year After 1 Jan 2014 Not year 12 18 years | 1st year |  | False |  | False |  |  | 18 years
2nd year After 1 Jan 2014 Not year 12 18 years | 2nd year |  | False |  | False |  |  | 18 years
3rd year After 1 Jan 2014 Not year 12 18 years | 3rd year |  | False |  | False |  |  | 18 years
4th year After 1 Jan 2014 Not year 12 18 years | 4th year |  | False |  | False |  |  | 18 years
1st year After 1 Jan 2014 Not year 12 19 years | 1st year |  | False |  | False |  |  | 19 years
2nd year After 1 Jan 2014 Not year 12 19 years | 2nd year |  | False |  | False |  |  | 19 years
3rd year After 1 Jan 2014 Not year 12 19 years | 3rd year |  | False |  | False |  |  | 19 years
4th year After 1 Jan 2014 Not year 12 19 years | 4th year |  | False |  | False |  |  | 19 years
1st year After 1 Jan 2014 Not year 12 20 years | 1st year |  | False |  | False |  |  | 20 years
2nd year After 1 Jan 2014 Not year 12 20 years | 2nd year |  | False |  | False |  |  | 20 years
3rd year After 1 Jan 2014 Not year 12 20 years | 3rd year |  | False |  | False |  |  | 20 years
4th year After 1 Jan 2014 Not year 12 20 years | 4th year |  | False |  | False |  |  | 20 years
1st year After 1 Jan 2014 Year 12 Under 18 | 1st year |  | False |  | True |  |  | Under 18
2nd year After 1 Jan 2014 Year 12 Under 18 | 2nd year |  | False |  | True |  |  | Under 18
3rd year After 1 Jan 2014 Year 12 Under 18 | 3rd year |  | False |  | True |  |  | Under 18
4th year After 1 Jan 2014 Year 12 Under 18 | 4th year |  | False |  | True |  |  | Under 18
1st year After 1 Jan 2014 Year 12 18 years | 1st year |  | False |  | True |  |  | 18 years
2nd year After 1 Jan 2014 Year 12 18 years | 2nd year |  | False |  | True |  |  | 18 years
3rd year After 1 Jan 2014 Year 12 18 years | 3rd year |  | False |  | True |  |  | 18 years
4th year After 1 Jan 2014 Year 12 18 years | 4th year |  | False |  | True |  |  | 18 years
1st year After 1 Jan 2014 Year 12 19 years | 1st year |  | False |  | True |  |  | 19 years
2nd year After 1 Jan 2014 Year 12 19 years | 2nd year |  | False |  | True |  |  | 19 years
3rd year After 1 Jan 2014 Year 12 19 years | 3rd year |  | False |  | True |  |  | 19 years
4th year After 1 Jan 2014 Year 12 19 years | 4th year |  | False |  | True |  |  | 19 years
1st year After 1 Jan 2014 Year 12 20 years | 1st year |  | False |  | True |  |  | 20 years
2nd year After 1 Jan 2014 Year 12 20 years | 2nd year |  | False |  | True |  |  | 20 years
3rd year After 1 Jan 2014 Year 12 20 years | 3rd year |  | False |  | True |  |  | 20 years
4th year After 1 Jan 2014 Year 12 20 years | 4th year |  | False |  | True |  |  | 20 years
1st year 3 years After 1 Jan 2014 Not 21 | 1st year | 3 years | False |  |  |  | False
2nd year 3 years After 1 Jan 2014 Not 21 | 2nd year | 3 years | False |  |  |  | False
3rd year 3 years After 1 Jan 2014 Not 21 | 3rd year | 3 years | False |  |  |  | False
1st year 3 years 21 | 1st year | 3 years |  |  |  |  | True
2nd year 3 years 21 | 2nd year | 3 years |  |  |  |  | True
3rd year 3 years 21 | 3rd year | 3 years |  |  |  |  | True
1st year 4 years 21 | 1st year | 4 years |  |  |  |  | True
2nd year 4 years 21 | 2nd year | 4 years |  |  |  |  | True
3rd year 4 years 21 | 3rd year | 4 years |  |  |  |  | True
4th year 4 years 21 | 4th year | 4 years |  |  |  |  | True
Stage 1 After 1 Jan 2014 Not Year 12 Not 21 | Stage 1 |  | False |  | False |  | False
Stage 2 After 1 Jan 2014 Not Year 12 Not 21 | Stage 2 |  | False |  | False |  | False
Stage 3 After 1 Jan 2014 Not Year 12 Not 21 | Stage 3 |  | False |  | False |  | False
Stage 4 After 1 Jan 2014 Not Year 12 Not 21 | Stage 4 |  | False |  | False |  | False
Stage 1 After 1 Jan 2014 Year 12 Not 21 | Stage 1 |  | False |  | True |  | False
Stage 2 After 1 Jan 2014 Year 12 Not 21 | Stage 2 |  | False |  | True |  | False
Stage 3 After 1 Jan 2014 Year 12 Not 21 | Stage 3 |  | False |  | True |  | False
Stage 4 After 1 Jan 2014 Year 12 Not 21 | Stage 4 |  | False |  | True |  | False
Stage 1 After 1 Jan 2014 21 | Stage 1 |  | False |  |  |  | True
Stage 2 After 1 Jan 2014 21 | Stage 2 |  | False |  |  |  | True
Stage 3 After 1 Jan 2014 21 | Stage 3 |  | False |  |  |  | True
Stage 4 After 1 Jan 2014 21 | Stage 4 |  | False |  |  |  | True
Stage 1 Before 1 Jan 2014 Year 10 or less Not 21 | Stage 1 |  | True |  |  | Year 10 or less | False
Stage 2 Before 1 Jan 2014 Year 10 or less Not 21 | Stage 2 |  | True |  |  | Year 10 or less | False
Stage 3 Before 1 Jan 2014 Year 10 or less Not 21 | Stage 3 |  | True |  |  | Year 10 or less | False
Stage 4 Before 1 Jan 2014 Year 10 or less Not 21 | Stage 4 |  | True |  |  | Year 10 or less | False
Stage 1 Before 1 Jan 2014 Year 11 Not 21 | Stage 1 |  | True |  |  | Year 11 | False
Stage 2 Before 1 Jan 2014 Year 11 Not 21 | Stage 2 |  | True |  |  | Year 11 | False
Stage 3 Before 1 Jan 2014 Year 11 Not 21 | Stage 3 |  | True |  |  | Year 11 | False
Stage 4 Before 1 Jan 2014 Year 11 Not 21 | Stage 4 |  | True |  |  | Year 11 | False
Stage 1 Before 1 Jan 2014 Year 12 Not 21 | Stage 1 |  | True |  |  | Year 12 | False
Stage 2 Before 1 Jan 2014 Year 12 Not 21 | Stage 2 |  | True |  |  | Year 12 | False
Stage 3 Before 1 Jan 2014 Year 12 Not 21 | Stage 3 |  | True |  |  | Year 12 | False
Stage 4 Before 1 Jan 2014 Year 12 Not 21 | Stage 4 |  | True |  |  | Year 12 | False
Stage 1 Before 1 Jan 2014 21 | Stage 1 |  | True |  |  |  | True
Stage 2 Before 1 Jan 2014 21 | Stage 2 |  | True |  |  |  | True
Stage 3 Before 1 Jan 2014 21 | Stage 3 |  | True |  |  |  | True
Stage 4 Before 1 Jan 2014 21 | Stage 4 |  | True |  |  |  | True
Stage 1 After 1 Jan 2014 Not Year 12 | Stage 1 |  | False |  | False
Stage 2 After 1 Jan 2014 Not Year 12 | Stage 2 |  | False |  | False
Stage 3 After 1 Jan 2014 Not Year 12 | Stage 3 |  | False |  | False
Stage 4 After 1 Jan 2014 Not Year 12 | Stage 4 |  | False |  | False
Stage 1 After 1 Jan 2014 Year 12 | Stage 1 |  | False |  | True
Stage 2 After 1 Jan 2014 Year 12 | Stage 2 |  | False |  | True
Stage 3 After 1 Jan 2014 Year 12 | Stage 3 |  | False |  | True
Stage 4 After 1 Jan 2014 Year 12 | Stage 4 |  | False |  | True
1st year | 1st year
2nd year | 2nd year
3rd year | 3rd year
4th year | 4th year
1st six months | 1st six months
2nd six months | 2nd six months
3rd six months | 3rd six months
4th six months | 4th six months
Stage 1 Before 1 Jan 2014 Not 21 | Stage 1 |  | True |  |  |  | False
Stage 2 Before 1 Jan 2014 Not 21 | Stage 2 |  | True |  |  |  | False
Stage 3 Before 1 Jan 2014 Not 21 | Stage 3 |  | True |  |  |  | False
Stage 4 Before 1 Jan 2014 Not 21 | Stage 4 |  | True |  |  |  | False
1st year 3 years Before 1 Jan 2014 21 | 1st year | 3 years | True |  |  |  | True
2nd year 3 years Before 1 Jan 2014 21 | 2nd year | 3 years | True |  |  |  | True
3rd year 3 years Before 1 Jan 2014 21 | 3rd year | 3 years | True |  |  |  | True
1st year 3 years After 1 Jan 2014 21 | 1st year | 3 years | False |  |  |  | True
2nd year 3 years After 1 Jan 2014 21 | 2nd year | 3 years | False |  |  |  | True
3rd year 3 years After 1 Jan 2014 21 | 3rd year | 3 years | False |  |  |  | True
1st year 4 years Before 1 Jan 2014 21 | 1st year | 4 years | True |  |  |  | True
2nd year 4 years Before 1 Jan 2014 21 | 2nd year | 4 years | True |  |  |  | True
3rd year 4 years Before 1 Jan 2014 21 | 3rd year | 4 years | True |  |  |  | True
4th year 4 years Before 1 Jan 2014 21 | 4th year | 4 years | True |  |  |  | True
1st year 4 years After 1 Jan 2014 21 | 1st year | 4 years | False |  |  |  | True
2nd year 4 years After 1 Jan 2014 21 | 2nd year | 4 years | False |  |  |  | True
3rd year 4 years After 1 Jan 2014 21 | 3rd year | 4 years | False |  |  |  | True
4th year 4 years After 1 Jan 2014 21 | 4th year | 4 years | False |  |  |  | True