The nested If Then Else formula needs to be followed as below to ensure that expected results are shown. To create a nested If Then Else formula, you first need to include in the Template the column(s) you wish to compare. Example: Template name: English Targets – Year 6 Aspect: English Achieved | Result Set:…