This table lists the mnemonics you can use for manipulation:

Mnemonic Description Explanation
Ax[n.n] Intermediate Rounding

Rounds an intermediate result by the amount n.n before it is used further in the formula. The value of x determines whether the rounding is up, down, or natural. You can set x to one of the following:

  • U - Round up
  • D - Round down
  • N - Round to the nearest multiple

For example, if you enter AU[10.0], the system rounds the intermediate result up to the nearest £10.

An example of using intermediate rounding is given in Intermediate Rounding Example.

Mx[n.n] Substitute Intermediate Result

Substitutes a fixed value for n.n for the intermediate result if the result is greater or less than n.n. Set x to specify whether substitution occurs when n.n is greater or less than the result.

That is, if x is:

  • MA - n.n is substituted if the result is greater than n.n.
  • MI - n.n is substituted if the result is less than n.n.

For example, if you enter MA[10.0], and the intermediate result is £10.98, the system substitutes £10 as the result.

UEaaaaaaa User Exits

Uses a bespoke process to evaluate the operand. 'aaaaaaa' represents the ID of the process, which can be any length or combination of characters.

For example, a user exit might be called UE1.

Additionally, there are some standard exits available to all users which are detailed in User Exits.