Functions for mathematical calculations

These functions perform mathematical operations on numeric values, and return the result. You can use these to make calculations in imports, reports, or models.

ACOS

Returns the arccosine, or inverse cosine, of a given number.

ACOS(data)

Example:
ACOS(-0.5) = 2.094395

ACOSH

Returns the inverse hyperbolic cosine of a given number.

ACOSH(data)

Example:
ACOSH(10) = 2.993222

ASIN

Returns the arcsine, or inverse sine, of a given number.

ASIN(data)

Example:
ASIN(-0.5) = -0.523599

ASINH

Returns the inverse hyperbolic sine of a given number.

ASINH(data)

Example:
ASINH(10) = 2.998223

ATAN

Returns the arctangent, or inverse tangent, of a given number.

ATAN(data)

Example:
ATAN(1) = 0.785398

ATAN2

Returns the arctangent, or inverse tangent, of the given coordinates.

ATAN2(data, number)

Example:
ATAN2(1, 1) = 0.785398

ATANH

Returns the inverse hyperbolic tangent of a given number.

ATANH(data)

Example:
ATANH(-0.1) = -0.100335

COS

Returns the cosine of a given number.

COS(data)

Example:
COS(1.047) = 0.500171

COSH

Returns the hyperbolic cosine of a given number.

COSH(data)

Example:
COSH(4) = 27.308233

DEGREES

Returns the result of converting radians to degrees.

DEGREES(data)

Example:
DEGREES(3) = 171.887339

EXP

Returns e raised to the power of a given number. The inverse of the EXP function is LN.

EXP(data)

Example:
EXP(1) = 2.718282

FACT

Returns the factorial of a given number.

FACT(data)

Example:
FACT(5) = 120

LN

Returns the natural logarithm of a given number. LN is the inverse of the EXP function.

LN(data)

Example:
LN(86) = 4.454347

LN10

Returns the natural logarithm of 10. No parameters are required.

LN10()

Example:
LN10() = 2.302585

LOG

Returns the logarithm of a number to a specified base.

LOG(data, base)

Example:
LOG(8, 2) = 3

LOG10

Returns the base-10 logarithm of a given number.

LOG10(data)

Example:
LOG10(86) = 1.934498

MEDIAN

Returns the median of numeric values in the given cell range or data array. You can specifiy multiple ranges.

MEDIAN(data, data, ..)

Example:
MEDIAN(3, 4, 5, 6, 7) = 5

MOD

Returns the remainder from a division between two given numbers.

MOD(data, number)

Example:
MOD(3, 2) = 1

MODE

Returns the most frequently occurring value in the given cell range or data array. You can specifiy multiple ranges.

MODE(data, data, ..)

Example:
MODE(3, 4, 4, 5, 6, 7) = 4

PI

Returns the value of PI.

PI()

Example:
PI() = 3.141593

POWER

Returns the result of a given number raised to a given power.

POWER(data, number)

Example:
POWER(5, 2) = 25

QUOTIENT

Returns the integer portion of a division between two given numbers.

QUOTIENT(data, number)

Example:
QUOTIENT(5, 2) = 2

RADIANS

Returns the result of converting degrees to radians.

RADIANS(data)

Example:
RADIANS(270) = 4.712389

SIN

Returns the sine of a given number.

SIN(data)

Example:
SIN(PI()/2) = 1

SINH

Returns the hyperbolic sine of a given number.

SINH(data)

Example:
SINH(2) = 3.62686

SQRT

Returns the positive square root of a given number.

SQRT(data)

Example:
SQRT(16) = 4

STDEVP

Calculates the standard deviation based on all values in the given cell range or data array. You can specifiy multiple ranges.

STDEVP(data, data, ..)

Example:
=STDEVP(3, 4, 5, 6, 7) = 1.414214

TAN

Returns the tangent of a given number.

TAN(data)

Example:
TAN(0.785) = 0.999204

TANH

Returns the hyperbolic tangent of a given number.

TANH(data)

Example:
TANH(2) = 0.964028

VARP

Calculates the variance based on all values in the given cell range or data array. You can specifiy multiple ranges.

VARP(data, data, ..)

Example:
VARP(3, 4, 5, 6, 7) = 2