Operators

• +, -, *, / Basic calculations (Add, Subtract, Multiply, Divide)
  • Support for: : and ÷ (Division) and × (Multiplication)
• ^ Exponent; 2^3 = 8
• % Modulo, Returns the remainder of an integer division: 5 % 2 = 1

Functions

• sqrt(x): Square Root; sqrt(9) = 3
• nrt(n, x): n-th Root; nrt(3, 8) = ∛8 = 2
• sin(x), cos(x), tan(x): Trigonometric functions for radians
• sindeg(x), cosdeg(x), tandeg(x): Trigonometric functions for degrees
• arcsin(x), arccos(x), arctan(x): Trigonometric arcus functions for radian
• arcsindeg(x), arccosdeg(x), arctandeg(x): Trigonometric arcus functions for degrees
• log(a, x): Logarithm based a; log(10, 100) = 2
• ln(x): Natural logarithm (log based e); ln(42) = log(e, 42)
• e(x): Exponential function with base e; e(1) ≈ 2.71828; e(2) ≈ 2.71828²
• abs(x): absolute value, converts negative values into positive values; abs(-3) = 3
• round(x): Rounds the value to next integer value; round(2.1) = 2, round(2.5) = 3
• round(x, p): Round the value with precision; round(1.247, 2) = 1.25
• floor(x): Rounds the value down to next integer value; floor(2.8) = 2
• ceil(x): Rounds the value up to next integer value; ceil(2.2) = 3
• sgn(x): Returns the sign of a number, -1 for negative values, 1 for positive and 0 for 0
• min(x, y): Returns the smallest number of the argument list; min(23, 12, 42) = 12
• max(x, y): Returns the smallest number of the argument list; max(23, 12, 42) = 42
• cs(x): Returns the cross sum of given numbers; cs(99) = 18, cs(99, 88) = 16
• csi(x): Returns the iterated cross sum of given numbers; cs(99) = 9, cs(99, 88) = 7

Note, that all decimal values need to be inserted with a dot as decimal character. Other way round, a function may return a dot-delimited decimal value, which could yield unexpected results in your entire formula.

• bww(x), av(x): Returns the sum of alphabet values of a text; av(ABCXYZ) = 1 + 2 + 3 + 24 + 25 + 26 = 81
• len(x): Returns the number of characters of a text; len(ABCXYZ) = 6

Constants

• pi: ~3.1415926…
• phi: Golden Ratio, ~1.61803…
• ln10: Natural logarithm of 10; = ln(10)
• ln2: Natural logarithm of 2; = ln(2)
• log10e: Logarithm based 10 of e; = log(10, e)
• log2e: Logarithm based 2 of e; = log(2, e)
• sqrt2: Square Root of 2; = sqrt(2)
• sqrt1_2: Square Root of 1/2; = sqrt(1/2)