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.
|
|||||||||||||||||||||||||
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.
|
|||||||||||||||||||||||||
N |
MULTIPLY |
N |
N |
||||||||||||||||||||||
Operator MULTIPLY can only be used with numbers.
|
|||||||||||||||||||||||||
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.
|
|||||||||||||||||||||||||
{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:
|
|||||||||||||||||||||||||
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.
|
|||||||||||||||||||||||||
{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:
|
|||||||||||||||||||||||||
N |
EXPONENT |
N |
N |
||||||||||||||||||||||
Operator EXPONENT elevates the number to the indicated power .
|