Arithmetic

OPERAND 1

OPERATOR

OPERAND 2

RESULT

F, N

SUM

N

F, N

Operator SUM has to ways to operate. Sum of numbers and dates. For the second case, the days can be summed up to a date, resulting a date.

Operand 1

Operator

Operand 2

Result

SALDIA

SUMA        

COMISSION

NAUX_01

F, N

RESTA

F, N

N

Operator SUBTRACTION manipulates the decrease of numbers and dates. For the second case, the dates subtraction is in the number of days between the two dates.

Operand 1

Operator

Operand 2

Result

AÑOFINPER

SUBTRACTION        

10000

NAUX_01

N

MULTIPLY

N

N

Operator MULTIPLY can only be used with numbers.

Operand 1

Operator

Operand 2

Result

SALDIA

MULTIPICA

DIASPERIOD

NAUX_01

N

DIVIDE

N

N

Operator DIVISION can only be used with numbers. If there is a division with 0, in the calculation log, there will be a mistake.

Operand 1

Operator

Operand 2

Result

SALDIA

DIVIDE

8

SALHORA

{decimals}

TRUNCATE

N

N

Operator TRUNCATE has to ways to operate. If the decimals are not placed in the OPERAND1, the decimals truncate. If the decimals are placed in the OPERAND1, the number of decimals indicated are truncated.

Example:

Operand 1

Operator

Operand 2

Result

Evaluation

1

TRUNCA

125.475617

Result

= 125.40

2

TRUNCA

125.475617

Result

= 125.47

0

TRUNCA

125.475617

Result

= 125.00

 

TRUNCA

125.475617

Result

= 125.00

N

RESIDUE

N

N

Operator RESIDUE performs the full division and reports the residue of this division.

Example:

Normal Division: 5/2 = 2.5        Full Division: 5/2 = 2 RESIDUE 1.

Operand 1

Operator

Operand 2

Result

PERIODO

RESIDUO

2

NAUX_01

{decimals}

ROUNDING

N

N

Operator ROUNDING, when the decimals are not placed, it rounds two decimals up, according to the currency procedure (to hundredth, 1 and 2 decrease to 0; 3 and 4 increase to 5; 6 and 7 decrease to 5; 8 and 9 increase to 0). If the decimals are placed in OPERAND1, it arithmetically rounds up (if it is smaller than 5, it decreases; if it is higher than 5, it increases).

Example:

Operand 1

Operator

Operand 2

Result

Evaluation

2

ARREDONDAMENTO

125.475617

Result

= 125.48

 

ARREDONDAMENTO

125.475617

Result

= 125.45

N

EXPONENT

N

N

Operator EXPONENT elevates the number to the indicated power .

Operand 1

Operator

Operand 2

Result

Evaluation

5

EXPONENTE

3

NAUX_01

=125