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.
 • @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.