63
11.2.2. Formula definition
1) Types of calculation
Arithmetic operations
The
basic
f
our arithmetic operations are available.
Note: X and Y in the table indicate a formula or number.
Comparison
Comparison is done and the result is given as
1 (satisfied) or 0 (unsatisfied).
Note: X and Y in the table indicate a formula or number.
Logical operations
Binary logical operations are done and the result is returned as 1 or 0.
Note: X and Y in the table indicate a formula or number. X and Y should be
expressible in terms of 0 or 1.
Other operations
The following calculations can also be done.
Note: X in the table indicates a formula or number.
Operation
Symbol Example
Remarks
Ad
X
+
Y
Subtraction -
X
–
Y
Multiplication *
X
*
Y
Division /
X
/
Y
Remainder %
X
%
Y
Exponential ^
X
^
Y
Operation
Symbol Example
Remarks
Equal value
==
X
==
Y
Unequal value
!=
X
!=
Y
More than
>>
X
>>
Y
Less than
<<
X
<<
Y
Equal or more than
>=
X
>=
Y
Equal or less than
<=
X
<=
Y
Operation
Symbol
Example
Remarks
Logical AND
AND
X
AND
Y
Logical OR
OR
X
OR
Y
Exclusive OR
XOR
X
XOR
Y
Negation NOT
NOT (
X
)
Put the object being
negated in parentheses.
Operation
Symbol
Example
Remarks
Round up after the decimal point
CEL
CEL(
X
)
Round down after the decimal point
FLR
FLR(
X
)
Absolute value
ABS
ABS(
X
)
Square root
SQR
SQR(
X
)
Power of e
EXP
EXP(
X
)
Natural logarithm (base e)
LOG
LOG(
X
)
Common logarithm (base 10)
LOG10
LOG10(
X
)
