This section introduces mathematical functions used for report making by listing their descriptions, syntax, parameters, return values and options, and giving related examples.
Description:
Compute absolute value of the specified data.
Syntax:
abs(numberExp)
Parameter:
|
numberExp |
Data for which you want to compute the absolute value |
Return value:
Numeric type
Example:
Example 1: abs(-3245.54) Return 3245.54
Example 2: abs(-987) Return 987
Description:
Compute arc cosine value of the specified data, which is a real number in the range of -1~1.
Related functions:
asin() Compute arc sine value of the specified data.
atan() Compute arc tangent value of the specified data.
Syntax:
acos(number)
Parameter:
|
number |
The real number for which you want to compute the arc cosine |
Return value:
Arc cosine value
Example:
Example 1: acos(-1) Return 3.141592653589793
Example 2: acos(cos(pi()/2)) Return 1.5707963267948966
Example 3: acos(cos(0)) Return 0.0
Description:
Compute arc sine value of the specified data, which is a real number in the range of -1~1.
Related functions:
acos() Compute arc cosine value of the specified data.
atan() Compute arc tangent value of the specified data.
Syntax:
asin(number)
Parameter:
|
number |
The real number for which you want to compute the arc sine value |
Return value:
Arc sine value
Example:
Example 1: asin(-1) Return -1.5707963267948966
Example 2: asin(sin(pi()/2)) Return 1.5707963267948966
Example 3: asin(sin(0)) Return 0.0
Description:
Compute arc tangent value of the specified data, which is a real number.
Related functions:
asin() Compute arc sine value of the specified data.
acos() Compute arc cosine value of the specified data.
Syntax:
atan(number)
Parameter:
|
number |
The real number for which you want to compute the arc tangent |
Return value:
Arc tangent value
Example:
Example 1: atan(1) Return 0.7853981633974483
Example 2: atan(tan(pi()/2)) Return 1.5707963267948966
Example 3: atan(tan(0)) Return 0.0
Description:
Truncate data at the specified position and carry the remaining part if any.
Related functions:
floor: Truncate data at the specified position and reject all the remaining part if any.
round: Truncate data at the specified position and round off the remaining part.
Syntax:
ceil(numberExp, {nExp})
Parameter:
|
numberExp |
Data to be truncated |
|
nExp |
An integer specifying the truncate position; taken as 0 when it is omitted >0: Move the decimal point to the right for nExp places <0: Move the decimal point to the left for nExp places =0: Indicate the current decimal place |
Return value:
Numeric type
Example:
Example 1: ceil(3450001.004,0) Return 3450002.0
Example 2: ceil(3450001.004,-1) Return 3450010.0
Example 3: ceil(3450001.004,-2) Return 3450100.0
Example 4: ceil(3450001.004,1) Return 3450001.1
Example 5: ceil(3450001.004,2) Return 3450001.01
Description:
Compute cosine value of the specified data measured in radians.
Related functions:
sin() Compute sine value of the specified data.
tan() Compute tangent value of the specified data.
Syntax:
cos(numberExp)
Parameter:
|
numberExp |
The radian of the cosine to be computed |
Return value:
Float type
Example:
Example 1: cos(pi()) Return -1
Example 2: cos(pi(2)) Return 1
Description:
Compute e to the nExpth power.
Syntax:
exp(nExp)
Parameter:
|
nExp |
The exponent |
Return value:
Numeric type
Example:
Example 1: exp(4.3) Return 73.69979369959579
Description:
Compute factorial of the specified data
Syntax:
fact(nExp)
Parameter:
|
nExp |
Data for which you want to compute the factorial |
Return value:
Long integer (64 bit)
Example:
Example 1: fact(10) Return 3628800
Description:
Truncate data at the specified position and reject all the remaining part if any.
Related functions:
ceil: Truncate data at the specified position and carry the remaining part if any.
round: Truncate data at the specified position and round off the remaining part.
Syntax:
floor(numberExp, {nExp})
Parameter:
|
numberExp |
Data to be truncated |
|
nExp |
An integer specifying the position from which data is to be truncated >0: Move the decimal point to the right for nExp places <0: Move the decimal point to the left for nExp places =0: Indicate the current decimal place |
Return value:
Numeric type
Example:
Example 1: floor(3451231.234,0) Return 3451231.0
Example 2: floor(3451231.234,-1) Return 3451230.0
Example 3: floor(3451231.234,-2) Return 3451200.0
Example 4: floor(3451231.234,1) Return 3451231.2
Example 5: floor(3451231.234,2) Return 3451231.23
Description:
Compute the natural logarithm of the specified data.
Syntax:
ln(numberExp)
Parameter:
|
numberExp |
Data for which you want to compute the natural logarithm |
Return value:
Numeric type
Example:
Example 1: ln(54) Return 3.9889840465642745
Description:
Compute the logarithm to base 10.
Syntax:
lg (numberExp)
Parameter:
|
numberExp |
Data for which you want to compute the logarithm to base 10 |
Return value:
Numeric type
Example:
Example 1: lg(54) Return 1.7323937598229684
Description:
Compute the circumference-to-diameter ratio or its multiple.
Syntax:
pi(numberExp)
Parameter:
|
numberExp |
The multiple; the function returns circumference ratio when the parameter is absent |
Return value:
Circumference ratio or its multiple
Example:
Example 1: pi() Return 3.141592653589793
Example 2: pi(2) Return 6.283185307179586
Description:
Compute number xExp raised to the nExpth power, or takes an nExpth root of xExp; use reciprocal (1/nExp), to find the root.
Syntax:
power(xExp, nExp)
Parameter:
|
xExp |
Base |
|
nExp |
Power, whose default is 2; find the root when it is the reciprocal |
Return value:
Numeric type
Example:
Example 1: power(2,4) Return 16.0
Example 2: power(16,1/4) Return 2.0
Example 3: power(5) Return 25
Description:
Get a random number.
Syntax:
rand(n)
Parameter:
|
n |
An integer; without it the function returns a random float number between 0 and 1.0 |
Return value:
Numeric type
Option:
|
@s |
Set the seed value for generating a random number |
Example:
Example 1: rand() Get a random number in the range of [0, 1.0)
Example 2: rand()*100 Get a random float number in the range of [0, 100)
Example 3: int(rand()*100) Get a random integer in the range of [0, 100)
Example 4: The seed value for generating a random number
|
|
A |
|
|
1 |
=to(1,5) |
Horizontal expansion |
|
2 |
=rand@s(5) |
|
|
3 |
=rand() |
|
|
4 |
=rand@s(5) |
|
|
5 |
=rand() |
The 5 random numbers generated in A5 and A3 are identical |
Description:
Convert the red, green, blue, and transparency values respectively to the corresponding color value.
Syntax:
rgb( redIntExp, greenIntExp, blueIntExp{, alphaIntExp} )
Parameter:
|
redIntExp |
The integer expression indicating the red, whose value is between 0-255 |
|
greenIntExp |
The integer expression indicating the green, whose value is between 0-255 |
|
blueIntExp |
The integer expression indicating the blue, whose value is between 0-255 |
|
alphaIntExp |
The integer expression indicating the transparency, whose value is between 0-255; 0 represents total transparency and 255 indicates total opaqueness; the other values represent various levels of transparency respectively; Default value is 255 |
Return value:
A 64-bit long integer
Example:
Example 1: rgb(123,123,123) Return -8684677
Example 2: rgb(123,123,123,123) Return 2071690107
Example 3: rgb(123,123,123,255) Return -8684677
Example 4: rgb(123,123,123,0) Return 8092539
Description:
Truncate data at the specified position and round off the remaining part.
Related functions:
ceil: Truncate data at the specified position and carry the remaining part if any.
floor: Truncate data at the specified position and reject all the remaining part if any.
Syntax:
round(numberExp, {nExp})
Parameter:
|
numberExp |
Data to be truncated |
|
nExp |
An integer specifying the position at which data is truncated >0: Truncate data at nExp decimal place(s) to the right of the decimal point <0: Truncate data at nExp decimal place(s) to the left of the decimal point =0: Truncate data at the current decimal place |
Return value:
Numeric type
Example:
Example 1: round(3451251.274,0) Return 3451251.0
Example 2: round(3451251.274,-1) Return 3451250.0
Example 3: round(3451251.274,-2) Return 3451300.0
Example 4: round(3451251.274,1) Return 3451251.3
Example 5: round(3451251.274,2) Return 3451251.27
Description:
Judge whether the specified data is a positive number, a negative number or 0; return 1 for a positive number, -1 for a negative number or 0 for 0.
Syntax:
sign(number)
Parameter:
|
number |
Data for which you want to judge whether it is positive or negative |
Return value:
Integer type
Example:
Example 1: sign(-10) Return -1
Example 2: sign(30) Return 1
Example 3: sign(0) Return 0
Description:
Compute the sine value of the specified data measured in radians.
Related functions:
cos() Compute the cosine value of the specified data.
tan() Compute the tangent value of the specified data.
Syntax:
sin(number)
Parameter:
|
number |
The radian for which you want to compute the sine value |
Return value:
Float type
Example:
Example 1: sin(pi()) Return 1.2246467991473532E-16
Example 2: sin(pi(2)) Return -2.4492935982947064E-16
Example 3: sin(pi()/2) Return 1.0
Description:
Find the square root of a number through number1/nExp. When nExp is omitted, the function gets the square root of the number through √number.
Syntax:
sqrt(number,nExp)
Parameter:
|
number |
Data for which you want to find the square root |
|
nExp |
The power |
Return value:
Numeric type
Example:
Example 1: sqrt(100) Return 10.0
Example 2: sqrt(99) Return 9.9498743710662
Example 3: sqrt(16,4) Return 2.0
Description:
Compute the tangent value of the specified data measured in radians.
Related functions：
sin() Compute the sine value of the specified data.
cos() Compute the cosine value of the specified data.
Syntax:
tan(number)
Parameter:
|
number |
The radian for which you want to compute the tangent value |
Return value:
Float type
Example:
Example 1: tan(pi()/2) Return 1.633123935319537E16
Example 2: tan(pi(2)) Return -2.4492935982947064E-16