Expression Editor Functions - Mathematical Category

Function	Description of Returned Value
Abs	Returns the absolute value of a number. The absolute value of a number is the number without its sign. Format: Abs(N) Where N is any real number.
ACos	Returns the arccosine of a number. The arccosine is the angle whose cosine is N. Format: ACos(N) Where N is the cosine of the angle. N must be in the range [-1, 1]. The angle returned is in radians.
ACosH	Returns the inverse hyperbolic cosine of a number. Format: ACosH(N) Where N is any real number in the range [1, infinity].
ASin	Returns the arcsine of a number. The arcsine is the angle whose sine is N. Format: ASin(N) Where N is the sine of the angle. N must be in the range [-1, 1]. The angle returned is in radians.
ASinH	Returns the inverse hyperbolic sine of a number. Format: ASinH(N) Where N is any real number in the range [1, infinity].
ATan	Returns the arctangent of a number. The arctangent is the angle whose tangent is N. Format: ATan(N) Where N is the tangent of the angle. The angle returned is in radians.
ATan2	Returns the arctangent of the specified x- and y-coordinates. The arctangent is the angle from the X-axis to a line containing the origin (0, 0) and a point with coordinates (X, Y). Format: ATan2(X, Y) Where X is the x-coordinate of the point and Y is the y-coordinate of the point.
ATanH	Returns the inverse hyperbolic tangent of a number. Format: ATanH(N) Where N is any real number in the range [-1, 1].
Ceiling	Returns the number rounded up (away from zero), to the nearest multiple of significance. Format: Ceiling(number, significance) Example: Ceiling(4.82, 0.05) will round a price of $4.82 up to the next 5 cents.
Combin	Returns the number of combinations for a given number of items. Format: Combin(N, n) Where N is the number of items to choose from and n is the number of items chosen in each combination.
Cos	Returns the cosine of a number. Format: Cos(N) Where N is the angle in radians.
CosH	Returns the hyperbolic cosine of a number. Format: CosH(N) Where N is any real number.
Degrees	Converts radians to degrees. Format: Degrees(N) Where N is the angle in radians.
Even	Returns the number rounded up to the nearest even integer. Format: Even(number)
Exp	Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm. Exp is the inverse of Ln, the natural logarithm of a number. Format: Exp(N) Where N is the exponent applied to the base e.
Fact	Returns the factorial of a number. The factorial of a number is equal to 123...N. If the number is not an integer, it is rounded down to the next lowest integer. Format: Fact(N) Where N is greater than or equal to 0.
Fixed	Rounds to a specified number of decimal places and returns the value in text format. Format: Fixed(number, decimal_places, no_commas)
Floor	Returns the number rounded down (towards zero), to the nearest multiple of significance. Format: Floor(number, significance) Example: Floor(4.82, 0.05) will round a price of $4.82 down to the next 5 cents.
Int	Rounds a number down to the next lowest integer. Format: Int(N) Where N is any real number.
Ln	Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904). Format: Ln(N) Where N is a positive real number.
Log	Returns the logarithm of a number to the specified base. Format: Log(N, base) Where N is a positive real number, and base is the base of the logarithm. If base is left blank, base 10 is used.
Log10	Returns the base 10 logarithm of a number. Format: Log10(N) Where N is a positive real number.
Mod	Returns the remainder from a division. Format: Mod(N, divisor) Where N is the number for which to find the remainder when it is divided by the divisor. Example: Mod(11, 3) = 2
Odd	Returns the number rounded up to the nearest odd integer. Format: Odd(number)
Permut	Returns the number of permutations for a number of things.
Pi	Returns the value of pi (3.14159265359). Format: Pi()
Pow	Returns the result of a number raised to a power. Format: Pow(number, power)
Power	Returns the result of a number raised to a power. Format: Power(number, power)
Product	Returns the product of all the arguments. Format: Product(N1, N2, ...) Where N1, N2, ... are the numbers to multiply.
Radians	Converts degrees to radians. Format: Radians(N) Where N is the angle in degrees.
Rand	Returns a random integer number from 0 to a specified number, or 1 if omitted. A new random number is returned every time the function is calculated. Format: Rand(N) Where N is the upper limit of the random value.
Rank	Returns the rank of a number in a list of numbers. This is its size relative to the other values in the list; that is, if you were to sort the list, the rank of the number is its position. Format: Rank(number, ref, order)
Round	Rounds a number to a specified number of decimal places. Format: Round(N, D) Where N is the number to round and D is the number of decimal places. If D is 0, N is rounded to the nearest integer. If D is negative, N is rounded to the left of the decimal point. Example: Round(42.95, -1) = 40
RoundDown	Rounds a number down to a specified number of decimal places.
RoundUp	Rounds a number up to a specified number of decimal places.
Sign	Returns 1 if the specified number is positive and 0 if the number is negative. Format: Sign(N) Where N is any real number.
Sin	Returns the sine of a number. Format: Sin(N) Where N is the angle in radians.
SinH	Returns the hyperbolic sine of a number. Format: SinH(N) Where N is any real number.
Sqr	Returns the square of a number. Format: Sqr(N) Where N is any real number.
Sqrt	Returns the positive square root of a number. Format: Sqrt(N) Where N is any positive real number.
SqrtPi	Returns the square root of a number multiplied by pi. Format: SqrtPi(N) Where N is any positive real number.
Sum	Returns the sum of all the arguments. Format: Sum(N1, N2, ...) Where N1, N2, ... are the numbers to add.
SumSq	Returns the sum of the squares of all the arguments. Format: SumSq(N1, N2, ...) Where N1, N2, ... are the numbers to square and then add.
Tan	Returns the tangent of a number. Format: Tan(N) Where N is the angle in radians.
TanH	Returns the hyperbolic tangent of a number. Format: TanH(N) Where N is any real number.
Trunc	Truncates a number to a specified number of decimal places. Format: Trun(number, num_digits)
Truncate	Truncates a number to a specified number of decimal places.

Abs

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Format: Abs(N)

Where N is any real number.

ACos

Returns the arccosine of a number. The arccosine is the angle whose cosine is N.

Format: ACos(N)

Where N is the cosine of the angle. N must be in the range [-1, 1]. The angle returned is in radians.

ACosH

Returns the inverse hyperbolic cosine of a number.

Format: ACosH(N)

Where N is any real number in the range [1, infinity].

ASin

Returns the arcsine of a number. The arcsine is the angle whose sine is N.

Format: ASin(N)

Where N is the sine of the angle. N must be in the range [-1, 1]. The angle returned is in radians.

ASinH

Returns the inverse hyperbolic sine of a number.

Format: ASinH(N)

Where N is any real number in the range [1, infinity].

ATan

Returns the arctangent of a number. The arctangent is the angle whose tangent is N.

Format: ATan(N)

Where N is the tangent of the angle. The angle returned is in radians.

ATan2

Returns the arctangent of the specified x- and y-coordinates. The arctangent is the angle from the X-axis to a line containing the origin (0, 0) and a point with coordinates (X, Y).

Format: ATan2(X, Y)

Where X is the x-coordinate of the point and Y is the y-coordinate of the point.

ATanH

Returns the inverse hyperbolic tangent of a number.

Format: ATanH(N)

Where N is any real number in the range [-1, 1].

Ceiling

Returns the number rounded up (away from zero), to the nearest multiple of significance.

Format: Ceiling(number, significance)

Example: Ceiling(4.82, 0.05) will round a price of $4.82 up to the next 5 cents.

Combin

Returns the number of combinations for a given number of items.

Format: Combin(N, n)

Where N is the number of items to choose from and n is the number of items chosen in each combination.

Cos

Returns the cosine of a number.

Format: Cos(N)

Where N is the angle in radians.

CosH

Returns the hyperbolic cosine of a number.

Format: CosH(N)

Where N is any real number.

Degrees

Converts radians to degrees.

Format: Degrees(N)

Where N is the angle in radians.

Even

Returns the number rounded up to the nearest even integer.

Format: Even(number)

Exp

Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm. Exp is the inverse of Ln, the natural logarithm of a number.

Format: Exp(N)

Where N is the exponent applied to the base e.

Fact

Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...*N. If the number is not an integer, it is rounded down to the next lowest integer.

Format: Fact(N)

Where N is greater than or equal to 0.

Fixed

Rounds to a specified number of decimal places and returns the value in text format.

Format: Fixed(number, decimal_places, no_commas)

Floor

Returns the number rounded down (towards zero), to the nearest multiple of significance.

Format: Floor(number, significance)

Example: Floor(4.82, 0.05) will round a price of $4.82 down to the next 5 cents.

Int

Rounds a number down to the next lowest integer.

Format: Int(N)

Where N is any real number.

Ln

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).

Format: Ln(N)

Where N is a positive real number.

Log

Returns the logarithm of a number to the specified base.

Format: Log(N, base)

Where N is a positive real number, and base is the base of the logarithm. If base is left blank, base 10 is used.

Log10

Returns the base 10 logarithm of a number.

Format: Log10(N)

Where N is a positive real number.

Mod

Returns the remainder from a division.

Format: Mod(N, divisor)

Where N is the number for which to find the remainder when it is divided by the divisor.

Example: Mod(11, 3) = 2

Odd

Returns the number rounded up to the nearest odd integer.

Format: Odd(number)

Permut

Returns the number of permutations for a number of things.

Pi

Returns the value of pi (3.14159265359).

Format: Pi()

Pow

Returns the result of a number raised to a power.

Format: Pow(number, power)

Power

Returns the result of a number raised to a power.

Format: Power(number, power)

Product

Returns the product of all the arguments.

Format: Product(N1, N2, ...)

Where N1, N2, ... are the numbers to multiply.

Radians

Converts degrees to radians.

Format: Radians(N)

Where N is the angle in degrees.

Rand

Returns a random integer number from 0 to a specified number, or 1 if omitted. A new random number is returned every time the function is calculated.

Format: Rand(N)

Where N is the upper limit of the random value.

Rank

Returns the rank of a number in a list of numbers. This is its size relative to the other values in the list; that is, if you were to sort the list, the rank of the number is its position.

Format: Rank(number, ref, order)

Round

Rounds a number to a specified number of decimal places.

Format: Round(N, D)

Where N is the number to round and D is the number of decimal places. If D is 0, N is rounded to the nearest integer. If D is negative, N is rounded to the left of the decimal point.

Example: Round(42.95, -1) = 40

RoundDown

Rounds a number down to a specified number of decimal places.

RoundUp

Rounds a number up to a specified number of decimal places.

Sign

Returns 1 if the specified number is positive and 0 if the number is negative.

Format: Sign(N)

Where N is any real number.

Sin

Returns the sine of a number.

Format: Sin(N)

Where N is the angle in radians.

SinH

Returns the hyperbolic sine of a number.

Format: SinH(N)

Where N is any real number.

Sqr

Returns the square of a number.

Format: Sqr(N)

Where N is any real number.

Sqrt

Returns the positive square root of a number.

Format: Sqrt(N)

Where N is any positive real number.

SqrtPi

Returns the square root of a number multiplied by pi.

Format: SqrtPi(N)

Where N is any positive real number.

Sum

Returns the sum of all the arguments.

Format: Sum(N1, N2, ...)

Where N1, N2, ... are the numbers to add.

SumSq

Returns the sum of the squares of all the arguments.

Format: SumSq(N1, N2, ...)

Where N1, N2, ... are the numbers to square and then add.

Tan

Returns the tangent of a number.

Format: Tan(N)

Where N is the angle in radians.

TanH

Returns the hyperbolic tangent of a number.

Format: TanH(N)

Where N is any real number.

Trunc

Truncates a number to a specified number of decimal places.

Format: Trun(number, num_digits)

Truncate

Truncates a number to a specified number of decimal places.