|
ABS |
Returns the absolute value of a number |
|
ACOS |
Returns the arccosine of a number |
|
ACOSH |
Returns the inverse hyperbolic cosine of a number |
|
ASIN |
Returns the arcsine of a number |
|
ASINH |
Returns the inverse hyperbolic sine of a number |
|
ATAN |
Returns the arctangent of a number |
|
ATAN2 |
Returns the arctangent from x- and y- coordinates |
|
ATANH |
Returns the inverse hyperbolic tangent of a number |
|
CEILING |
Rounds a number to the nearest integer or to the nearest multiple of significance |
|
COMBIN |
Returns the number of combinations for a given number of objects |
|
COS |
Returns the cosine of a number |
|
COSH |
Returns the hyperbolic cosine of a number |
|
COUNTIF |
Counts the number of non-blank cells within a range which meet the given criteria |
|
DEGREES |
Converts radians to degrees |
|
EVEN |
Rounds a number up to the nearest even integer |
|
EXP |
Returns e raised to the power of a given number |
|
FACT |
Returns the factorial of a number |
|
FACTDOUBLE |
Returns the double factorial of a number |
|
FLOOR |
Rounds a number down, toward zero |
|
GCD |
Returns the greatest common divisor |
|
INT |
Rounds a number down to the nearest integer |
|
LCM |
Returns the least common multiple |
|
LN |
Returns the natural logarithm of a number |
|
LOG |
Returns the logarithm of a number to a specified base |
|
LOG10 |
Returns the base-10 logarithm of a number |
|
MDETERM |
Returns the matrix determinant of an array |
|
MINVERSE |
Returns the matrix inverse of an array |
|
MMULT |
Returns the matrix product of two arrays |
|
MOD |
Returns the remainder from division |
|
MROUND |
Returns a number rounded to the desired multiple |
|
MULTINOMIAL |
Returns the multinomial of a set of numbers |
|
ODD |
Rounds a number up to the nearest odd integer |
|
PI |
Returns the value of Pi |
|
POWER |
Returns the result of a number raised to a power |
|
PRODUCT |
Multiplies its arguments |
|
QUOTIENT |
Returns the integer portion of a division |
|
RADIANS |
Converts degrees to radians |
|
RAND |
Returns a random number between 0 and 1 |
|
RANDBETWEEN |
Returns a random number between the numbers you specify |
|
ROMAN |
Converts an Arabic numeral to Roman, as text |
|
ROUND |
Rounds a number to a specified number of digits |
|
ROUNDDOWN |
Rounds a number down, toward zero |
|
ROUNDUP |
Rounds a number up, away from zero |
|
SERIESSUM |
Returns the sum of a power series based on the formula |
|
SIGN |
Returns the sign of a number |
|
SIN |
Returns the sine of the given angle |
|
SINH |
Returns the hyperbolic sine of a number |
|
SQRT |
Returns a positive square root |
|
SQRTPI |
Returns the square root of (number * PI) |
|
SUBTOTAL |
Returns a subtotal in a list or database |
|
SUM |
Adds its arguments |
|
SUMIF |
Adds the cells specified by a given criteria |
|
SUMPRODUCT |
Returns the sum of the products of corresponding array components |
|
SUMSQ |
Returns the sum of the squares of the arguments |
|
SUMX2MY2 |
Returns the sum of the difference of squares of corresponding values in two arrays |
|
SUMX2PY2 |
Returns the sum of the sum of squares of corresponding values in two arrays |
|
SUMXMY2 |
Returns the sum of squares of differences of corresponding values in two arrays |
|
TAN |
Returns the tangent of a number |
|
TANH |
Returns the hyperbolic tangent of a number |
|
TRUNC |
Truncates a number to an integer |