Operators

  • +, -, *, / Basic calculations (Add, Subtract, Multiply, Divide)
  • ^ 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*
  • arcsin(x), arccos(x), arctan(x): Trigonometric arcus functions*
  • 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
  • floor(x): Rounds the value down to next integer value: floor(2.8) = 2
  • sgn(x): Returns the sign of a number, -1 for negative values, 1 for positive and 0 for 0

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.

*) Trigonometric functions take radian values instead of decimal degrees. To convert degree values to radian:

rad = deg * pi / 180

sin(90) for 90 degrees needs to be written as sin(90 * pi / 180)

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)