Calculations functions

<< 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