ABS
Description
ABS(value)
Input | value: a number. Type: number. |
Output | Output the absolute value of the number. Type: number. |
Examples
ABS(2) >> 2
ABS(-2) >> 2
EXP
Description
EXP(raise_value)
Input | raise_value: a number. Type: number. |
|---|---|
Output | Output value of raise_value to the power of e. e eauqls to 2.71828182845904. Type: number. |
Examples
EXP(0) >> 1
EXP(3) >> 20.085536923187668
INT
Description
INT(value)
Input | value: a number. Type: number. |
|---|---|
Output | Round down the value and return the nearest integer. Type: integer. |
Examples
INT(4.8) >> 4
INT(-4.8) >> -5
LOG
Description
LOG(value, base_value)
Input | value: a number. Type: number.
base [optional]: the base of the logarithm. The default is 10. Type: number. |
|---|---|
Output | Return the power the base_value should be raised to produce value. Type: number. |
Examples
LOG(16,2) >> 4
LOG(10) >> 1
MAX
Description
MAX(value_1, value_2, ...)
Input | value_1: the first number or to be examined. Type: number, text that can be parsed as number or cells and arrays that contain number.
value_2 [optional]: the second number to be examined. Type: Type: number, text that can be parsed as number or cells and arrays that contain number. |
|---|---|
Output | Return the maximum among the numbers. |
Examples
MAX(1,2,ARRAY(3,4)) >> 4
Suppose B3:D3 contain values 5, 6 and 7:
MAX(1,2,B14:D14) >> 7
MIN
Description
MIN(value_1, value_2, ...)
Input | value_1: the first number or to be examined. Type: number, text that can be parsed as number or cells and arrays that contain number.
value_2 [optional]: the second number to be examined. Type: Type: number, text that can be parsed as number or cells and arrays that contain number. |
|---|---|
Output | Return the minimum among the numbers. |
Examples
MIN(ARRAY(1,2),3) >> 1
Suppose B3:D3 contain values 5, 6 and 7:
MIN(B14:D14,8) >> 5
RAND
Description
RAND()
Input | / |
|---|---|
Output | Return a random number between 0 and 1. Type: number. |
Examples
RAND() >> 0.5835384192223745
You can use RAND()*(b-a)*a to generate a number between a and b:
RAND()*(2-1)+1 >> 1.1284356662679649
RAND()*(3-2)+2 >> 2.787429962205664
ROUND
Description
ROUND(value, num_digit)
Input | value: the value to be rounded. Type: number.
num_digit: the number of digits based on which the value is rounded. Type: integer. |
|---|---|
Output | If num_digit is positive, round value to the specified number of digits. If num_digit equals to zero, round value to the nearest integer. If num_digit is negative (e.g. -1, -2 or -3), round value to the number of places (e.g. 10th, hundredth or thousandth place). |
Examples
ROUND(2.15,1) >> 2.2
ROUND(2.149,1) >> 2.1
ROUND(-1.475,2) >> -1.48
ROUND(21.5,-1) >> 20
ROUNDDOWN
Description
ROUNDDOWN(value, num_digit)
Input | value: the value to be rounded. Type: number.
num_digit: the number of digits based on which the value is rounded. Type: integer. |
|---|---|
Output | If num_digit is positive, round down value to the specified number of digits. If num_digit equals to zero, round down value to the nearest integer. If num_digit is negative (e.g. -1, -2 or -3), round down value to the number of places (e.g. 10th, hundredth or thousandth place). |
Examples
ROUNDDOWN(3.2, 0) >> 3
ROUNDDOWN(3.14159, 3) >> 3.141
ROUNDDOWN(31415.92654, -2) >> 31400
ROUNDUP
Description
ROUNDUP(value, num_digit)
Input | value: the value to be rounded. Type: number.
num_digit: the number of digits based on which the value is rounded. Type: integer. |
|---|---|
Output | If num_digit is positive, round up value to the specified number of digits. If num_digit equals to zero, round up value to the nearest integer. If num_digit is negative (e.g. -1, -2 or -3), round up value to the number of places (e.g. 10th, hundredth or thousandth place). |
Examples
ROUNDUP(3.2,0) >> 4
ROUNDUP(3.14159, 3) >> 3.142
ROUNDUP(31415.92654, -2) >> 31500
TRUNC
Description
TRUNC(value, num_digit)
Input | value: the value to be rounded. Type: number.
num_digit [optional]: the number of digits after which all other digits will be truncated. The default is zero. Type: integer. |
|---|---|
Output | If num_digit is positive, truncate the digits after num_digit. If num_digit is zero, truncate all digits. |
Examples
TRUNC(8.9) >> 8
TRUNC(-8.9) >> -8
TRUNC(PI()) >> 3
TRUNC(PI(),2) >> 3.14
Previous：Common array processing functions
