The following is a list of all, valid arithmetical functions and operators for the Calculation feature.
Symbol Equivalent Description Example |
|
( ) Prioritizes an expression 5*(1+1) = 10 |
|
! FACT Factorial 5! = 120fact(5) = 120 |
|
% Percentage 35% = 0.35 |
|
^ ** Raised to the power of 4 ^ 5 = 1024 |
|
* Multiply by 3 * 6 = 18 |
|
/ Divide by 9 / 2 = 4.5 |
|
\ DIV Integer divide by 9 \ 2 = 4 |
|
MOD Modulo (remainder) 7 mod 4 = 3 |
|
+ Add 1 + 1 = 2 |
|
- Subtract 9 - 5 = 4 |
|
> Greater than 9 > 2 = 1 |
|
< Less than 7 < 4 = 0 |
|
== = Equal test 5 == 4 = 0 |
|
>= => Greater or equal 3 >= 3 = 1 |
|
<= =< Less or equal #h3E <= 9 = 0 |
|
<> Not equal #b10101 <> 20 = 1 |
|
NOT Bitwise NOT NOT(15) = -16 |
|
AND & Bitwise AND #b101 AND #h1E=4 |
|
OR | Bitwise OR 13 OR 6 = 15 |
|
XOR Bitwise Exclusive OR 9 XOR 3 = 10 |
|
EQV Bitwise Equivalence 6 QV 9 = -16 |
|
IMP Bitwise Implication 1 IMP 5 = -1 |
|
IIF If condition IIf(1+1=2,4,5) = 4 |
|
MIN Minimum value min(10,3,27,15) = 3 |
|
MAX Maximum value max(1,9)=9 |
|
SIN Sine sin(pi) = 0 |
|
COS Cosine cos(pi) = -1 |
|
TAN Tangent tan(pi) = 0 |
|
ASIN Arc sine asin(1) = 1.570 |
|
ACOS Arc cosine acos(-1) = 3.141 |
|
ATAN ATN Arc tangent atan(0) = 0 |
|
SEC Secant sec(0) = 1 |
|
CSC Cosecant csc(1) = 1.18 |
|
COT Cotangent cot(1) = 0.642 |
|
SINH Hyperbolic sine sinh(3) = 10.01 |
|
COSH Hyperbolic cosine cosh(2) = 3.76 |
|
TANH Hyperbolic tangent tanh(1) = 0.76 |
|
COTH Hyperbolic cotangent coth(1) = 1.31 |
|
SECH Hyperbolic secant sech(0) = 1 |
|
CSCH Hyperbolic cosecant csch(1) = 0.85 |
|
ASINH Hyperbolic arc sine sinh(2) = 1.44 |
|
ACOSH Hyperbolic arc cosine acosh(9) = 2.89 |
|
ATANH Hyperbolic arc tangent atanh(.1) = 0.10 |
|
ACOTH Hyperbolic arc cotangent acoth(7) = 0.14 |
|
ASECH Hyperbolic arc secant asech(.3) = 1.87 |
|
ACSCH Hyperbolic arc cosecant acsch(2) = 0.48 |
|
ABS Absolute value abs(-8) = 8 |
|
EXP e to the power of exp(3) = 20.08 |
|
EXP2 2 to the power of exp2(3) = 8 |
|
EXP10 10 to the power of exp10(3) = 1000 |
|
LOG LN Natural log log(16) = 2.77 |
|
LOG2 Log base 2 log2(8) = 3 |
|
LOG10 Log base 10 og10(100) = 2 |
|
CEIL Round up ceil(6.2) = 7 |
|
RND Random number rnd(1) = .969 |
|
INT Truncate to an integer(round down)int(6.8) = 6 |
|
SGN SIGN Sign of expression (-1,0,or1) sgn(-9) = -1 |
|
SQR SQRT Square root sqr(64) = 8 |
For a complete list of the object functions available for Calculation, please click here.