-
67
-
13.2.2 Setting method of formula
1) Formula types
Mathematical calculation
Four arithmetic operations
are performed.
*
X
and
Y
indicate the formula or the numeric value.
Comparison calculation
The comparison
calculation is performed
and the result is;
1 (established) or
0 (not established)
*
X
and
Y
indicate the formula or the numeric value.
Logic operation
The logic operation for 1
or 0 is performed and the
result is returned as 1 or
0.
*
X
and
Y
indicate the formula or the numeric value.
Express
X
and
Y
as
0
or
1.
General calculation functions
The function calculation
is performed.
*
X
indicates the formula or the numeric value.
Symbol
Example
Remarks
Ad
X
+Y
Subtraction
-
X
-
Y
Multiplication *
X
*Y
Division /
X
/Y
Reminder %
X
%Y
Exponential ^
X
^Y
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
Symbol
Example
Remarks
Logical AND
AND
X
ANDY
Logical OR
OR
X
ORY
Exclusive OR
XOR
X
XORY
Negation NOT
NOT(X
)
Put the object being negative
in brackets.
Symbol
Example Remarks
Round up after the decimal
CEL
CEL(X
)
Round down after the decimal
FLR
FLR(X
)
Absolute value
ABS
ABS(X
)
Square root
SQR
SQR(X
)
Power of e
EXP
EXP(X
)
Natural logarithm (The base is e.)
LOG
LOG(X
)
Common logarithm (The base is 10.)
LOG10
LOG10(X
)