<< Click to Display Table of Contents >> Navigation: Macros > Macro commands and parameters > Macro functions > Calculations functions |
Function |
Purpose |
Example |
Result |
SUM |
Sum of two values |
Text(SUM(2,3)) |
5 |
DIFFERENCE |
Difference of two values |
Text(DIFFERENCE(2,3)) |
-1 |
DIF |
The absolute difference of two values |
Text(DIF(1,-2)) |
3 |
PRODUCT |
Product of two values |
Text(PRODUCT(2,3)) |
6 |
PIF |
Multiply with Pi |
Text(PIF(2)) |
6.28318531 |
QUOTIENT |
Quotient of two values |
Text(QUOTIENT(2,3)) |
0.66666667 |
DIV |
Division of two values, rounded towards zero |
Text(DIV(11,4)) |
2 |
MOD |
Remainder after the division of two values |
Text(MOD(11,4)) |
3 |