Overview of Numeric Functions

Editing data

Adding a column and filtering

Numeric fields (Some functions allow adding specified parameter values)

Component

Adding a calculation field

Trigonometric functions

COS

Returns the cosine of the given angle.

COS(0.5) returns 0.877582562.

COS(30*PI()/180) returns 0.866025404.

SIN

Returns the sine of a given angle.

SIN(10) returns –0.54.

SIN(45*PI()/180) returns 0.71.

TAN

Returns the tangent of the specified angle.

TAN(0.8) returns 1.029638557.

TAN(45*PI()/180) returns 1.

ACOS

Returns the arccosine of the given number.

ACOS(1) returns 0 (radians).

ACOS(0.5) returns 1.047197551 (PI/3 radians).

ACOS(0.5)*180/PI() returns 60 (degrees).

ASIN

Returns the arcsine value of the given number.

ASIN(0.5) returns 0.523598776 (PI/6 radians).

ASIN(1) returns 1.570796327 (PI/2 radians).

ASIN(0.5)*180/PI() returns 30 (degrees).

ATAN

Returns the arctangent value of the given number.

ATAN(-1) returns –0.785398163 (–PI/4 radians).

ATAN(0) returns 0 (radians).

ATAN(2)*180/PI() returns 63.43494882 (degrees).

ATAN2

Returns the arctangent of X and Y coordinates.

ATAN2(-2,2) returns 2.356194490192345 (3 * PI/4 radians).

ATAN2(2,2) returns 0.785398163 (PI/4 radians)

ATAN2(-2,2)*180/PI() returns 135 (degrees).

DEGREES

Converts radians into degrees.

DEGREES(PI()/2) returns 90.

DEGREES(3.1415926) returns 179.9999969.

RADIANS

Converts degrees to radians.

RADIANS(90) returns 1.570796327.

Power and logarithm

SQRT

Returns a non negative square root of sqrt.

SQRT(64) returns 8.

SQRT(-64) returns blank.

LOG

Returns the logarithm of a number according to any base number specified.

LOG(16,2) returns 4.

LOG(10) returns 1.

LOG(24,3) returns 2.89.

LOG10

Returns the base 10 logarithm.

LOG10(86) returns 1.93.

LOG10(10) returns 1.

LOG10(1E5) returns 5.

LN

Returns the natural logarithm of a number.

LN(86) returns 4.45437.

LN(2.7182818) returns 1.

LN(EXP(3)) returns 3.

EXP

Returns the n-th power of e. The constant e is the base of the natural logarithm, equal to 2.71828182845904.

EXP(0) returns 1.

EXP(3) returns 20.09.

EXP(LN(2)) returns 2.

POWER

Returns the power of a specified number.

POWER(6,2) returns 36.

POWER(14,5) returns 537824.

Numeric processing

FLOOR

Rounds number down, toward zero.

FLOOR(-2.5) returns –2.

FLOOR(2.5) returns 2.

CEILING

Returns number rounded up, away from zero.

CEILING(-2.5) returns –3.

CEILING(0.5) returns 1.

CEILING(1.25) returns 2.

MAX

Returns the maximum value in the parameter list.

MAX(1,2,3,4,5) returns 5.

MIN

Returns the minimum value in the parameter list.

MIN(1,2,3,4,5) returns 1.

ABS

Returns the absolute value of a specified number, which is always a non-negative number.

ABS(-1.5) returns 1.5.

ABS(0) returns 0.

ABS(2.5) returns 2.5.

TRUNC

Truncates a number to an integer by removing the fractional part of the number.

TRUNC(8.9) returns 8.

TRUNC(-8.9) returns –8.

TRUNC(-8.98,1) returns –8.9.

SIGN

Returns the positive or negative of a number.

SIGN(10) returns 1.

SIGN(4-4) returns 0.

SIGN(-0.00001) returns –1.

ROUND

Rounds a number to a specified number of digits.

ROUND(2.15,1) returns 2.

ROUND(2.149,1) returns 2.1.

ROUND(-1.475,2) returns –1.48.

Numeric calculation

FACT

Returns the factorial of a number.

FACT(1) returns 1.

FACT(1.9) equals FACT(1) equals 1.

MOD

Returns the remainder after number is divided by divisor.

MOD(3,2) returns 1.

MOD(-3,2) returns 1.

MOD(3,-2) returns –1.

PROMOTION

Returns the proportion increased from one value to the other.

PROMOTION(12,14) returns 0.166666666, indicating an increase of 16.6666666%.

Others

RANDBETWEEN

Returns a random integer between two values.

RANDBETWEEN(12.333, 13.233) only returns 13.

RANDBETWEEN(11.2,13.3) may return 12 or 13.

RANDBETWEEN(12.333, 12.233) only returns 12.

RAND

Returns an evenly distributed random  number greater than or equal to 0 and less than 1.

To get a random number ranging from 0 to 60 (excluded), use RAND()*60.

To get a random number ranging from 0 to 19 (excluded), use RAND()*19.

PI

The mathematical constant pi

SIN(PI()/2) returns 1.

The formula for the area of a circle is S=PI()*(r^2), in which S represents the area and R, the radius.

PI(3) returns 9.42.