Office Accelerator® Support

Equations

ASSIGN VarOut, Var1

VarOut = Var1

The value of Var1 is automatically converted to the same type as VarOut before assignment. Var1 can be a variable or constant.

CONCAT VarOut, Var1, Var2

VarOut = Var1.toString + Var2.ToString

The values of Var1 and Var2 are converted to strings and concatenated, then the result is converted to the same type as VarOut for assignment.

ADD VarOut, Var1, Var2

VarOut = Var1 + Var2

The values of Var1 and Var2 are converted to Double and the equation is evaluated, then the result is converted to the same type as VarOut for assignment.

SUBTRACT VarOut, Var1, Var2

VarOut = Var1 - Var2

The values of Var1 and Var2 are converted to Double and the equation is evaluated, then the result is converted to the same type as VarOut for assignment.

MULTIPLY VarOut, Var1, Var2

VarOut = Var1 * Var2

The values of Var1 and Var2 are converted to Double and the equation is evaluated, then the result is converted to the same type as VarOut for assignment.

DIVIDE VarOut, Var1, Var2

VarOut = Var1 / Var2

The values of Var1 and Var2 are converted to Double and the equation is evaluated, then the result is converted to the same type as VarOut for assignment.

INTDIVIDE VarOut, Var1, Var2

VarOut = Var1 \ Var2

The values of Var1 and Var2 are converted to Integer and the equation is evaluated, then the result is converted to the same type as VarOut for assignment. This is integer division which truncates any fractional part.