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.
pow(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.
ceil( x ) rounds x up.
floor( 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.