Numerical expressions

Numerical expressions may be any VBA compatible expression of a double result type.

Examples:

 

Expression

Result

sqr(4)

2

log(10)

2.302585092994

sin((355/113)/4)^2

0.50000008146034

 

Allowed expressions:

( )  parenthesis

+,-,*,/  add, subtract, multiply, divide

sqr()  square root

^  power

log()  natural logarithm

exp()  euler’s number to the power of the argument

sin(), cos(), tan() sine, cosine, tangent  (taking rad as argument)

asin(), acos(), atn() arc sine, arc cosine, arc tangent (giving rad as return value)

asinD(), acosD(), atnD() arc sine, arc cosine, arc tangent (giving degrees as return value)