This formula is only available for use where the outcome of the calculation is stored in a Marks (Integer), Marks (Decimal) or Comments aspect.

You can divide:

the value stored in one column by the value stored in another column.

the value stored in one column by a constant value.

a constant value by the value stored in a column.

Select Divisionfrom the Formula Typedrop-down list.

Select the first value (which is divided) and second column/constant value (which will divide by) (please see Selecting Column/Constant Valueson page 142).

This formula is only available for use where the outcome of the calculation is stored in a Marks (Integer), Marks (Decimal) or Comments aspect.

You can subtract:

the value stored in a column from the value stored in another column.

the value stored in a column from a constant value.

a constant value from the value stored in a column.

Select Differencefrom the Formula Typedrop-down list.

Select the first column/constant value (to be subtracted from) and the second column/constant value (to subtract) (please see Selecting Column/Constant Values on page 142).

NOTE: Any blank cell included in the calculation is treated as ‘0’. Where reference is made to cells displaying ages, the contents of the cell are converted to months before being included in the calculation. Where a reference is made to a cell displaying a grade, the value of the displayed grade is used.