Math and Trigonometry Functions

The functions that relate to mathematical calculations are:

 

ABS(expression)

This function calculates the absolute value of the specified value.

 

ACOS(x)

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

 

ACOSH(x)

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

 

ASIN(x)

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

 

ASINH(x)

This function calculates the inverse hyperbolic sine of a number.

 

ATAN(x)

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

 

ATAN2(x,y)

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

 

ATANH(x)

This function calculates the inverse hyperbolic tangent of a number.

 

CEILING(value1,value2)

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

argument

description

value

Number to round

signif

Number representing the rounding factor

example: CEILING(-2.78,-1) gives the result -3

 

 

COMBIN(k,n)

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

The number of combinations is calculated as follows:

Func-COMBIN

COS(angle)

This function returns the cosine of the specified angle.

 

COSH(value)

This function returns the hyperbolic cosine of the specified value.

 

COUNTIF(cellrange,condition)

COUNTIF(column,condition)

This function returns the number of cells that meet a certain condition.

argument

description

cellrange

Column or Range of cells to count

condition

Condition that determines which cells are counted, as a text, number, or expression (where expressions use the relational operators detailed in Operators in a Formula)

 

example: COUNTIF(A1:A15,"<200")

 

DEGREES(angle)

This function converts the specified value from radians to degrees.

 

EVEN(value)

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

example: EVEN(-2.5) gives the result -4

 

EXP(value)

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

 

FACT(number)

This function calculates the factorial of the specified number.

 

FACTDOUBLE(number)

This function calculates the double factorial of the specified number.

 

FLOOR(value1,value2)

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

 

GCD(number1,number2)

This function returns the greatest common divisor of two numbers.

 

INT(value)

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

 

LCM(number1,number2)

This function returns the least common multiple of two numbers.

 

LN(value)

This function returns the natural logarithm of the specified number.

 

LOG(base,number)

This function returns the logarithm base Y of a number X

 

LOG10(value)

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

 

MDETERM(array)

This function returns the matrix determinant of an array.

 

MINVERSE(array)

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

 

MMULT(array1,array2)

This function returns the matrix product for two arrays.

 

MOD(dividend,divisor)

This function returns the remainder of a division operation.

 

MROUND(number,multiple)

This function returns a number rounded to the desired multiple.

 

MULTINOMIAL(value1,value2,...)

MULTINOMIAL(column)

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

The arguments are the values to calculate in the multinomial. Each argument can be a double-precision floating point value, an integer value, or a column of the datasheet. Up to 255 arguments may be included. You can use a single column instead of a list of values. You can use multiple arrays or columns as well. If a column or an array contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.

 

ODD(value)

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

 

PI()

This function returns PI as 3.1415926536.

 

POWER(number,power)

This function raises the specified number to the specified power.

 

PRODUCT(value1,value2,...)

PRODUCT(column)

This function multiplies all the arguments and returns the product.

Each argument can be a double-precision floating-point value, an integer value, or a column of the datasheet. Up to 255 arguments may be included. You can use a single column instead of a list of values. You can use multiple arrays or columns as well. If a column or an array contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.

 

QUOTIENT(numerator,denominator)

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

 

RADIANS(value)

This function converts the specified number from degrees to radians.

 

RAND()

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

 

RANDBETWEEN(lower,upper)

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

 

ROMAN(number,style)

This function converts an arabic numeral to a roman numeral text equivalent.

 

ROUND(value,places)

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

 

ROUNDDOWN(value,places)

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

 

ROUNDUP(value,places)

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

 

SERIESSUM(x,n,m,coeff)

This function returns the sum of a power series.

 

SIGN(value)

This function returns the sign of a number or expression.

 

SIN(angle)

This function returns the sine of the specified angle.

 

SINH(value)

This function returns the hyperbolic sine of the specified number.

 

SQRT(value)

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

 

SQRTPI(multiple)

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

 

SUBTOTAL(functioncode,value1,value2,...)

SUBTOTAL(functioncode,array)

SUBTOTAL(functioncode,column)

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

Built-In Function

Function Code

AVERAGE

1

COUNT

2

COUNTA

3

MAX

4

MIN

5

PRODUCT

6

STDEV

7

STDEVP

8

SUM

9

VAR

10

VARP

11

Each additional argument can be a double-precision floating-point value, an integer value, or a column of the datasheet. Up to 255 arguments can be included. You can use a single column instead of a list of values. You can use multiple columns or arrays as well.

 

SUM(value1,value2,...)

SUM(column)

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

Each argument can be a double-precision floating-point value, an integer value, or a column of the datasheet. Up to 255 arguments may be included. You can use a single column instead of a list of values. You can use multiple columns or arrays as well.

 

SUMIF(array,condition,sumrange)

SUMIF(column,condition,sumcolumn)

This function adds the cells using a given criteria.

argument

description

array

Column or Range of cells to check; each cell in the array can be a double-precision floating-point value or an integer value

condition

Condition that determines which cells are added, as a text, number, or expression

sumrange

[Optional] Column or Range of cells to add; if omitted, then all the cells in the column are added

 

SUMPRODUCT(array1,array2,...)

SUMPRODUCT(column1,column2)

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

There must be at least two columns or arrays and optionally up to 255 columns as arguments. The columns must have the same dimension.

 

SUMSQ(value1,value2,...)

SUMSQ(column)

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

Each argument can be a double-precision floating-point value, an integer value, or a column of the datasheet. Up to 255 arguments may be included. You can use a single column instead of a list of values. You can use multiple columns or arrays as well.

 

SUMX2MY2(array_x,array_y)

SUMX2MY2(column_x,column_y)

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

The columns must be the same size.

 

SUMX2PY2(array_x,array_y)

SUMX2PY2(column_x,column_y)

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

The columns must be the same size.

 

SUMXMY2(array_x,array_y)

SUMXMY2(column_x,column_y)

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

The columns must be the same size.

 

TAN(angle)

This function returns the tangent of the specified angle.

 

TANH(value)

This function returns the hyperbolic tangent of the specified number.

 

TRUNC(number,digits)

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

 

 

 

See Also:


Formula Functions