We create a lot of documents that refer to whether a student is currently studying towards GCSEs or A-Levels and the year in which they will sit the exams. Rather than having multiple templates which need updating every year it would be extremely useful to be able to use simple logic (as in excel etc).
for example:
If(yeargroup in(9, 10, 11), "GCSE", "A Level")
and a similar solution for the year in which they sit the exam