I am trying to create what would be an Excel If Then If Then Else Formula in Sims.
I am trying to create the Levels of Progress made by individual students from their KS2 APS to their Target. For example, if a student had an APS of 26 and a Target grade C this would be 3 Levels Progress. How can I get Assessment Manager to calculate this?
I have been advised that I would need to give each KS2 APS and Target a value and add them together, then ask for an If Then Else formula however, because there are some many possibilities I don't see how this is possible.
Can someone please help or am I going to have to calculate these manually?
