3. Predefined Functions and Constants

All functions and predefined parameters are case-sensitive.

Predefined parameters:

PI

Ratio of the circumference of a circle to its diameter, approximately 3.14159.

EULER

Euler's constant and the base of natural logarithms, approximately 2.718.

LN2

Natural logarithm of 2, approximately 0.693.

LN10

Natural logarithm of 10, approximately 2.303.

LOG2E

Base 2 logarithm of E, approximately 1.443.

LOG10E

Base 10 logarithm of E, approximately 0.434.

SQRT1_2

Square root of 1/2; equivalently, 1 over the square root of 2, approximately 0.707.

SQRT2

Square root of 2, approximately 1.414.

Predefined functions:

abs

Returns the absolute value of a number.

sqrt

Returns the positive square root of a number.

pow

Returns base to the exponent power

log

Returns the natural logarithm (loge, also ln) of a number.

exp

Returns Ex, where x is the argument, and E is Euler's constant (2.718…), the base of the natural logarithm.

sin

Returns the sine of a number.

tan

Returns the tangent of a number.

cos

Returns the cosine of a number.

acos

Returns the arccosine of a number.

asin

Returns the arcsine of a number.

atan

Returns the arctangent of a number.

atan2

Returns the arctangent of the quotient of its arguments.

min

Returns the smallest of zero or more numbers.

max

Returns the largest of zero or more numbers.

cubic

Solves cubic equation in the form ax3 + bx2 + cx + d = 0.

quad

Solves quadratic equation.

iif

Allows to choose from a set of values based on a set of criteria.

ceil

Returns the smallest integer greater than or equal to a number.

floor

Returns the largest integer less than or equal to a number.

round

Returns the value of a number rounded to the nearest integer.

random

Returns a pseudo-random number between 0 and 1.