Mathematical functions

1234: Enters a constant number.

Addition: the addition (a + b) results in

  • (Number + Number) the sum of a and b, if both are numeric values,
  • (Text + …) or (… + Text) a compound text of a and b,
  • (Date + Number) the date a increased by b days,
  • (Date + Time interval) a date/time, that is date a increased by b,
  • (Time + Number) the time a increased by b milliseconds,
  • (Time + Time) the sum of time a and time b,
  • (Time + Time interval) the time a increased by the time interval b,
  • (Date/Time + Number) the date/time a increased by b milliseconds,
  • (Date/Time + Time interval) the date/time a increased by the time interval b,
  • (Time interval + Number) the time interval a increased by b milliseconds,
  • (Time interval + Time interval) the sum of both time intervals a and b.

Subtraction: the subtraction (a – b) results in

  • (Number – Number) the Number a – b,
  • (Date – Date) the time interval from b to a,
  • (Time/Date – Time/Date) the time interval from b to a,
  • Subtract b from a, see: addition

Multiplication: multiplies (a * b)

  • (Number * Number) the number a * b,
  • (Time interval * Number) the time interval a * b,

Division: divides (a / b)

  • (Number / Number) the number a / b,
  • (Time interval / Number) the time interval a / b,

√{} (x) calculates the square root of x.

2

(x) calculates the square of x.

^ (x, y) calculates the power of y to the base of x, in other words, x to the power of y.

e

( x ) calculates e to the power of x.

log10( x ) calculates the logarithm of x to the base 10.

ln( x ) calculates the natural logarithm of x, that is, to the base of e.

Logarithms to the base of y can be calculated with ln( x ) / ln( y ).

sin( x ) calculates the sinus of x (as a radian measure).

cos( x ) calculates the cosine of x (as a radian measure).

tan( x ) calculates the tangent of x (as a radian measure).

asin( x ) calculates the arc sinus of x (as a radian measure).

acos( x ) calculates the arc cosine of x (as a radian measure).

atan( x ) calculates the arc tangent of x (as a radian measure).

atan

2

( x ) calculates the square arc tangent of x (as a radian measure).

round( x ) rounds x to the nearest whole number.

round up( x ) rounds x up.

round down( x ) rounds x down.

sign( x ) results in -1, if x is negative, else 1.

absolute( x ) calculates the absolute amount of x, that is, x without a sign.

Example: absolute( -10 ) = absolute( 10 ) = 10.