List of valid arithmetical functions and operators for Calculation

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.