# 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()

Example:
ASIN(-0.5) = -0.523599

#### ASINH

Returns the inverse hyperbolic sine of a given number.

ASINH()

Example:
ASINH(10) = 2.998223

#### ATAN

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

ATAN()

Example:
ATAN(1) = 0.785398

#### ATAN2

Returns the arctangent, or inverse tangent, of the given X and Y coordinates.

ATAN2(number, number)

Example:
ATAN2(1, 1) = 0.785398

#### ATANH

Returns the inverse hyperbolic tangent of a given number.

ATANH()

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.

MEDIAN(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.

MODE(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)

Example:
QUOTIENT(5, 2) = 2

Returns the result of converting degrees to radians.

Example:

#### SIN

Returns the sine of a given number.

SIN()

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

#### SINH

Returns the hyperbolic sine of a given number.

SINH()

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.

STDEVP(data)

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

#### TAN

Returns the tangent of a given number.

TAN()

Example:
TAN(0.785) = 0.999204

#### TANH

Returns the hyperbolic tangent of a given number.

TANH()

Example:
TANH(2) = 0.964028

#### VARP

Calculates the variance based on all values in the given cell range or data array.

VARP(data)

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