Mathematical spreadsheet functions

Mathematical spreadsheet functions take one or more numeric values as arguments, and return a numeric value. You must enter all angles in radians for @COS, @SIN, and @TAN. Accordingly, @ASIN, @ATAN, and @ATAN2 return all angles in radians. To convert radians to degrees, use @DEGREES; to convert degrees to radians, use @RADIANS.

•
 
@ABS  Returns the absolute value of a specified number.
•
 
@ACOS  Returns the angle whose cosine is a specified value.
•
 
@ACOSH Returns the arc, or inverse, hyperbolic cosine of a number.
•
 
@ACOT Calculates the arc, or inverse, cotangent using the cotangent X of an angle.
•
 
@ACOTH Calculates the arc, or inverse, hyperbolic cotangent using the hyperbolic cotangent X of an angle.
•
 
@ACSC Calculates the arc, or inverse, cosecant using the cosecant X of an angle.
•
 
@ACSCH Calculates the arc, or inverse, hyperbolic cosecant using the hyperbolic cosecant X of an angle.
•
 
@ASEC Calculates the arc, or inverse, secant using the secant X of an angle.
•
 
@ASECH Calculates the arc, or inverse, hyperbolic secant using the hyperbolic secant X of an angle.
•
 
@ASIN  Returns the angle whose sine is a specified value.
•
 
@ASINH Calculates the arc, or inverse, hyperbolic sine using the hyperbolic sine X of an angle.
•
 
@ATAN  Returns the angle whose tangent is a specified value.
•
 
@ATAN2  Returns the angle represented by a specified pair of coordinates.
•
 
@ATANH Calculates the arc, or inverse, hyperbolic tangent using the hyperbolic tangent X.
•
 
@CEILING Rounds a number up to the nearest integer.
•
 
@COS  Returns the cosine of a specified angle.
•
 
@COSH Calculates the hyperbolic cosine of the angle X.
•
 
@COT Calculates the cotangent of angle X.
•
 
@COTH Calculates the hyperbolic cotangent of X.
•
 
@CSC Returns the cosecant of angle X, in radians.
•
 
@CSCH Calculates the hyperbolic cosecant of X.
•
 
@DEGREES Converts a specified value from radians to degrees.
•
 
@DFRAC Converts a decimal number to a whole number and fractional component.
•
 
@EVEN Rounds a number up to the nearest even integer.
•
 
@EXP  Returns the exponential of a specified value, which is the value of e (the mathematical constant) raised to the power of the specified value. The value must be less than or equal to 709.
•
 
@EXP2 Calculates the value of the constant e raised to the po
wer ( X^2).
•
 
@FACT Calculates the factorial of a number.
•
 
@FACTDOUBLE Returns the double factorial of a number.
•
 
@FACTLN Returns the natural logarithm of the factorial of n.
•
 
@FIB Calculates the nth term of a Fibonacci sequence.
•
 
@FLOOR Rounds a number down, toward zero.
•
 
@FRACD Converts a number with a fractional component to a decimal.
•
 
@GCD Calculates the greatest comman divisor of x and y.
•
 
@GEOSUM Calculates the geometric series that is sum of the terms of a geometric sequence of a number of terms (n) based on the first term and common ratio.
•
 
@INT  Returns the integer portion of of a specified value. In this @function, the number is simply truncated, not rounded off.
•
 
@INTXL Rounds the number x down to an integer value.
•
 
@LCM Calculates the least common multiple of x and y.
•
 
@LINTERP Performs linear interpolation between sets of xy pairs.
•
 
@LN  Returns the natural logarithm of a specified value. This is the logarithm of the number to the base e; @LN is the inverse of @EXP (the value must be greater than 0).
•
 
@LOG  Returns the logarithm of a specified value to base 10 (the value must be greater than 0).
•
 
@LOGBASE Calculates the logarithm of a specified number to the specified base.
•
 
@LOGCONV Converts a specified logarithm from one specified base to another.
•
 
@MDET Calculates the determinant of a matrix.
•
 
@MINVERSE Returns the inverse matrix for a matrix stored in a square array.
•
 
@MMULT Calculates the matrix product of two arrays.
•
 
@MOD  Returns the modulus of a specified value with respect to another. (Modulus is the remainder when the first is divided by the second.)
•
 
@MODULO Returns the remainder, or modulus, of x/y.
•
 
@MROUND Returns a number rounded to the desired multiple.
•
 
@MULT Calculates cumulative product of a set of numbers.
•
 
@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 Calculates the result of a specified number raised to a power.
•
 
@QUOTIENT Returns the integer portion of a division.
•
 
@RADIANS  Converts a specified value from degrees to radians.
•
 
@RAND  Returns a fractional random number between 0 and 1.
•
 
@RANDBETWEEN Returns a random number between the numbers you specify.
•
 
@ROMAN Returns the Roman numeral corresponding to a specified Arabic numeral, displaying it as text.
•
 
@ROOTN Calculates the nth root of a specified number.
•
 
@ROUND  Rounds off a specified value (with up to 15 digits) to a specified number of decimal places.
•
 
@ROUNDDOWN Rounds a positive number down with a specified precision and rounds a negative number the direction you specify.
•
 
@ROUNDDOWNXL Rounds positive and negative numbers toward zero.
•
 
@ROUNDUP Rounds a positive number up with a specified precision and rounds a negative number the direction you specify.
•
 
@ROUNDUPXL Rounds positive and negative numbers toward zero.
•
 
@SEC Returns the secant of angle X, in radians.
•
 
@SECH Calculates the hyperbolic secant of X.
•
 
@SERIESSUM Returns the sum of a power series based on a formula.
•
 
@SIGN Returns 1 if X is positive, 0 if X is zero, and 1 if X is negative.
•
 
@SIN  Returns the sine of a specified angle.
•
 
@SINH Returns the hyperbolic sine of X, in radians.
•
 
@SQRT  Returns the square root of a specified value (the value must be greater than or equal to 0).
•
 
@SQRTPI Returns the square root of a number multiplied by pi.
•
 
@TAN  Returns the tangent of a specified angle.
•
 
@TANH Calculates the hyperbolic tangent of X.
•
 
@TRANSPOSE Returns the transpose of cells.
•
 
@TRUNC Truncates a number to the precision you specify.

Mathematical spreadsheet functions