Mathematical Processing
Dialog
The Math Formula cell allows you to process numerical formulas. In the dialog that appears after double-clicking the column header, select [Math Formula:] from [Header Key].
See below for constants and functions that can be used. These can be combined to perform numerical operations.
Static Property
The Math Formula provides eight mathematical constants.
- M_E
- Euler number e (the base of the natural logarithm)
- M_PI
- π
- M_SQRT2
- Square root of 2
- M_SQRT1_2
- Square root of 1/２
- M_LN2
- Natural logarithm of 2
- M_LN10
- Natural logarithm of 10
- M_LOG2E
- Base 2 logarithm of e
- M_LOG10E
- Base 10 logarithm of e
Example
- M_PI
- Returns 3.141592653589793
Mathematical Functions
- abs(x)
- Returns the absolute value of x
- acos(x)
- Returns the arccosine of x
- acosh(x)
- Returns the hyperbolic arccosine of x.
- asin(x)
- Returns the arcsine of x,
- asinh(x)
- Returns the hyperbolic arcsine of x
- atan(x)
- Returns the arctangent of x as a numeric value between -π/2 and π/2
- atan2(y, x)
- Returns the arctangent of the quotient of its arguments
- atanh(x)
- Returns the hyperbolic arctangent of x
- cbrt(x)
- Returns the cubic root of x
- ceil(x)
- Returns x, rounded upwards to the nearest integer
- cos(x)
- Returns the cosine of x
- cosh(x)
- Returns the hyperbolic cosine of x
- exp(x)
- Returns the value of Ex
- floor(x)
- Returns x, rounded downwards to the nearest integer
- log(x)
- Returns the natural logarithm (㏒e) of x
- log10(x)
- Returns the base 10 logarithm (㏒10) of x
- max(x, y, z, ..., n)
- Returns the number with the highest value
- min(x, y, z, ..., n)
- Returns the number with the lowest value
- pow(x, y)
- Returns the value of x to the power of y (xy)
- random()
- Returns a random number between 0 and 1
- round(x)
- Rounds x to the nearest integer
- sin(x)
- Returns the sine of x
- sinh(x)
- Returns the hyperbolic sine of x
- sqrt(x)
- Returns the square root of x
- tan(x)
- Returns the tangent of an angle
- tanh(x)
- Returns the hyperbolic tangent of a number
- trunc(x)
- Returns the integer part of a number x
Examples
round()
- round(4.7)
- Returns 5
- round(4.4)
- Returns 4
pow()
- pow(8, 2)
- Returns 64
- sqrt(64)
- Returns 8
- abs(-4.7)
- Returns 4.7
- ceil(4.4)
- Returns 5
- floor(4.7)
- Returns 4
- sin(90 * PI / 180)
- Returns 1 (Converts 90 degrees to radians)
- cos(0 * PI / 180)
- Returns 1 (Converts 0 degree to radian)
- min(0, 150, 30, 20, -8, -200)
- Returns -200
- max(0, 150, 30, 20, -8, -200)
- Returns 150