Math
ABS
Description: Returns the absolute value of a value.
Example:
ABS(number)
ACOS
Description: Returns the inverse cosine.
Example:
ACOS(number)
ACOSH
Description: Returns the inverse hyperbolic cosine.
Example:
ACOSH(number)
ASIN
Description: Returns the inverse sine.
Example:
ASIN(number)
ASINH
Description: Returns the inverse hyperbolic sine.
Example:
ASINH(number)
ATAN
Description: Returns the inverse tangent.
Example:
ATAN(number)
ATAN2
Description: Returns the inverse tangent.
Example:
ATAN2(x_num,y_num)
ATANH
Description: Returns the inverse hyperbolic tangent.
Example:
ATANH(number)
AVG
Description: Returns the arithmetic mean of the listed arguments.
Example:
AVG(number1, number2,...)
CEILING
Description: Returns the rounded up value.
Example:
CEILING(number, significance)
COMBIN
Description: Returns the number of combinations.
Example:
COMBIN(number, number_chosen)
COS
Description: Returns the cosine.
Example:
COS(number)
COSH
Description: Returns the hyperbolic cosine.
Example:
COSH(number)
DEGREES
Description: Returns the degrees represented by the given radians.
Example:
DEGREES(angle)
EVEN
Description: Returns the number rounded up to the nearest even integer.
Example:
EVEN(number)
EXP
Description: Returns the value of e raised to the given argument.
Example:
EXP(number)
FACT
Description: Returns the factorial of the given value.
Example:
FACT(number)
FACTDOUBLE
Description: Returns the doublefactorial of the given value.
Example:
FACTDOUBLE(number)
Fixed
Description: Rounds off to a specified number of decimal places and returns the value in text format.
Example:
Fixed (number, decimal_places, no_commas)
FLOOR
Description: Returns the value rounded down to the nearest value.
Example:
FLOOR(number, significance)
GCD
Description: Returns the greatest common divisor of two or more given values.
Example:
GCD(number1, numer2, ...)
INT
Description: Returns the value rounded down to nearest integer.
Example:
INT(number)
LCM
Description: Returns the least common multiple of two or more given values.
Example:
LCM(number1, number2, ...)
LN
Description: Returns the natural logarithm of the value.
Example:
LN(number)
LOG
Description: Returns the logarithm to a given base.
Example:
LOG(number, base)
LOG10
Description: Returns the logarithm base 10.
Example:
LOG10(number)
MOD
Description: Returns the remainder after a division.
Example:
MOD(number, divisor)
MROUND
Description: Rounds a given number up or down to the nearest multiple of a given number
Example:
MROUND(number, multiple)
MULTINOMIAL
Description: Returns the ratio of the factorial of a sum of values to the product of factorials.
Example:
MULTINOMIAL(number1, (number2), ...)
N
Description: Converts the given value into a numeric value.
Example:
N(value)
ODD
Description: Returns the value to the nearest odd integer.
Example:
ODD(number)
PI
Description: Returns the pi.
Example:
PI( )
Pow
Description: Returns the value of one number raised to another number.
Example:
POW(number, power)
POWER
Description: Returns the result of a number raised to a power.
Example:
POWER(number, power)
PRODUCT
Description: Returns the product of the listed values.
Example:
PRODUCT(number1, number2, ...)
QUOTIENT
Description: Returns the integer portion of a division between two given numbers.
Example:
QUOTIENT(numerator, denominator)
RADIANS
Description: Returns the radians from given degrees.
Example:
RADIANS(angle)
RAND
Description: Returns a random value.
Example:
RAND( )
RANDBETWEEN
Description: Returns a random number that is between the given ranges.
Example:
RANDBETWEEN(start_num, end_num)
ROMAN
Description: Converts an Arabic number to a Roman numeral.
Example:
ROMAN(number, (form))
ROUND
Description: Returns the number to a specified number of digits.
Example:
ROUND(number, num_digits)
ROUNDDOWN
Description: Returns the number rounded down.
Example:
ROUNDDOWN(number, num_digits)
ROUNDUP
Description: Returns the number rounded up.
Example:
ROUNDUP(number, num_digits)
SIGN
Description: Returns the sign of the number.
Example:
SIGN(number)
SIN
Description: Returns the sine of the given angle.
Example:
SIN(number)
SinH
Description: Returns the hyperbolic sine.
Example:
SinH(value)
SQRT
Description: Returns the square root of a number.
Example:
SQRT(number)
SQRTPI
Description: Returns the square root of a given number multiplied by pi.
Example:
SQRTPI(number)
SUBTOTAL
Description: Returns a subtotal in a list
Example:
SUBTOTAL(function_Number, ref1, (ref2), ...)
Sum
Description: Returns the sum of the listed values.
Example:
Sum(number1, number2, ... number_n)
SumIf
Description: Returns the conditional sum of the listed values.
Example:
SumIf(range, criteria, sum_range)
SumIfs
Description: Sums the values in a given array that satisfy a set of given criteria
Example:
SumIfs(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
SUMPRODUCT
Description: Returns the sum of the products.
Example:
SUMPRODUCT(array1, array2, array3, ...)
SUMSQ
Description: Returns the sum of the squares.
Example:
SUMSQ(number1, number2, ...)
SUMX2MY2
Description: Returns the differences of the squares.
Example:
SUMX2MY2(array_x, array_y)
SUMX2PY2
Description: Returns the sum of the squares.
Example:
SUMX2PY2(array_x, array_y)
SumXmY2
Description: Returns the squares of the differences.
Example:
SumXmY2(array1, array2)
TAN
Description: Returns the tangent.
Example:
TAN(number)
TANH
Description: Returns the hyperbolic tangent.
Example:
TANH(number)
TRUNC
Description: Returns the number without a fractional part.
Example:
TRUNC(number, num_digits)