[]
        
(Showing Draft Content)

Math and Trigonometric Functions

Spread provides the following math and trigonometric functions, listed alphabetically.

Function

Description

ABS

This function calculates the absolute value of the specified value.

ACOS

This function calculates the arccosine, that is, the angle whose cosine is the specified value.

ACOSH

This function calculates the inverse hyperbolic cosine of the specified value.

ACOT

This function calculates the inverse arccotangent of a number.

ACOTH

This function calculates the inverse hyperbolic arccotangent of a number.

AGGREGATE

This function aggregate a list of numbers using a specified built-in function.

ARABIC

This function converts a Roman numeral text to an Arabic numeral equivalent.

ASIN

This function calculates the arcsine, that is, the angle whose sine is the specified value.

ASINH

This function calculates the inverse hyperbolic sine of a number.

ATAN

This function calculates the arctangent, that is, the angle whose tangent is the specified value.

ATAN2

This function calculates the arctangent of the specified x- and y-coordinates.

ATANH

This function calculates the inverse hyperbolic tangent of a number.

BASE

This function converts a number into a text representation with the given radix (base).

CEILING

This function rounds a number up to the nearest multiple of a specified value.

MATH

This function rounds a number up to the nearest integer or the nearest multiple of significance.

PRECISE

This function rounds a number up to the nearest integer or the nearest multiple of a specified value.

COMBIN

This function calculates the number of possible combinations for a specified number of items.

COMBINA

This function calculates the number of possible combinations with repetitions for a specified number of items.

COS

This function returns the cosine of the specified angle.

COSH

This function returns the hyperbolic cosine of the specified value.

COT

This function returns the cotangent of the specified angle.

COTH

This function returns the hyperbolic cotangent of the specified number.

CSC

This function returns the cosecant of the specified angle.

CSCH

This function returns the hyperbolic cosecant of the specified number.

DECIMAL

This function converts a text representation of a number in a given base into a decimal number.

DEGREES

This function converts the specified value from radians to degrees.

EVEN

This function rounds the specified value up to the nearest even integer.

EXACT

This function returns true if two strings are the same; otherwise, false.

EXP

This function returns e raised to the power of the specified value.

FACT

This function calculates the factorial of the specified number.

FACTDOUBLE

This function calculates the double factorial of the specified number.

MATH

This function rounds a number down to the nearest integer or the nearest multiple of significance.

PRECISE

This function rounds a number down to the nearest integer or the nearest multiple of a specified value.

GCD

This function returns the greatest common divisor of two numbers.

INT

This function rounds a specified number down to the nearest integer.

CEILING

This function returns a number up to the nearest integer or the nearest multiple of significance, regardless of the sign of significance.

LCM

This function returns the least common multiple of two numbers.

LET

This function assigns calculation results to names. Useful for storing intermediate calculations and values by defining names inside a formula. These names only apply within the scope of the LET function.

LN

This function returns the natural logarithm of the specified number.

LOG

This function returns the logarithm base Y of a number X.

LOG10

This function returns the logarithm base 10 of the number given.

MDETERM

This function returns the matrix determinant of an array.

MINVERSE

This function returns the inverse matrix for the matrix stored in an array.

MMULT

This function returns the matrix product for two arrays.

MOD

This function returns the remainder of a division operation.

MROUND

This function returns a number rounded to the desired multiple.

MULTINOMIAL

This function calculates the ratio of the factorial of a sum of values to the product of factorials.

MUNIT

This function returns the unit matrix for the specified dimension.

ODD

This function rounds the specified value up to the nearest odd integer.

PI

This function returns PI as 3.1415926536.

POWER

This function raises the specified number to the specified power.

PRODUCT

This function multiplies all the arguments and returns the product.

QUOTIENT

This function returns the integer portion of a division. Use this to ignore the remainder of a division.

RADIANS

This function converts the specified number from degrees to radians.

RAND

This function returns an evenly distributed random number between 0 and 1.

RANDARRAY

This function returns an array of random numbers.

RANDBETWEEN

This function returns a random number between the numbers you specify.

ROMAN

This function converts an Arabic numeral to a Roman numeral text equivalent.

ROUND

This function rounds the specified value to the nearest number, using the specified number of decimal places.

ROUNDDOWN

This function rounds the specified number down to the nearest number, using the specified number of decimal places.

ROUNDUP

This function rounds the specified number up to the nearest number, using the specified number of decimal places.

SEC

This function returns the secant of the specified angle.

SECH

This function returns the hyperbolic secant of the specified value.

SEQUENCE

This function returns the sum of a power series.

SERIESSUM

This function returns a sequence of numbers.

SIGN

This function returns the sign of a number or expression.

SIN

This function returns the sine of the specified angle.

SINH

This function returns the hyperbolic sine of the specified number.

SQRT

This function returns the positive square root of the specified number.

SQRTPI

This function returns the positive square root of a multiple of pi (p).

SUBTOTAL

This function calculates a subtotal of a list of numbers using a specified built-in function.

SUM

This function returns the sum of cells or range of cells.

SUMIF

This function adds the cells using the given criteria.

SUMIFS

This function adds the cells in a range using multiple criteria.

SUMPRODUCT

This function returns the sum of the products of cells. Multiplies corresponding components in the given arrays, and returns the sum of those products.

SUMSQ

This function returns the sum of the squares of the arguments.

SUMX2MY2

This function returns the sum of the difference of the squares of corresponding values in two arrays.

SUMX2PY2

This function returns the sum of squares of corresponding values in two arrays.

SUMXMY2

This function returns the sum of the square of the differences of corresponding values in two arrays.

TAN

This function returns the tangent of the specified angle.

TANH

This function returns the hyperbolic tangent of the specified number.

TRUNC

This function removes the specified fractional part of the specified number.