# Excel: Math and Trigonometry Functions

Functions in English | Functions in French | Description of Function |
---|---|---|

ABS | ABS | Returns the absolute value of a number. |

ACOS | ACOS | Returns the arccosine of a number. |

ACOSH | ACOSH | Returns the inverse hyperbolic cosine of a number. |

ACOT | ACOT | Returns the arccotangent of a number (2013). |

ACOTH | ACOTH | Returns the hyperbolic arccotangent of a number (2013). |

AGGREGATE | AGREGAT | Returns an aggregate in a list or database. |

ARABIC | ARABE | Converts a Roman number to Arabic, as a number (2013). |

ASIN | ASIN | Returns the arcsine of a number. |

ASINH | ASINH | Returns the inverse hyperbolic sine of a number. |

ATAN | ATAN | Returns the arctangent of a number. |

ATAN2 | ATAN2 | Returns the arctangent from x- and y-coordinates. |

ATANH | ATANH | Returns the inverse hyperbolic tangent of a number. |

BASE | BASE | Converts a number into a text representation with the given radix (base) (2013). |

CEILING | PLAFOND | Rounds a number to the nearest integer or to the nearest multiple of significance. |

CEILING.MATH | PLAFOND.MATH | Rounds a number up, to the nearest integer or to the nearest multiple of significance (2013). |

CEILING.PRECISE | PLAFOND.PRECIS | Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.. |

COMBIN | COMBIN | Returns the number of combinations for a given number of objects. |

COMBINA | COMBINA | Returns the number of combinations with repetitions for a given number of items (2013). |

COS | COS | Returns the cosine of a number. |

COSH | COSH | Returns the hyperbolic cosine of a number. |

COT | COT | Returns the hyperbolic cosine of a number (2013). |

COTH | COTH | Returns the cotangent of an angle (2013). |

CSC | CSC | Returns the cosecant of an angle (2013). |

CSCH | CSCH | Returns the hyperbolic cosecant of an angle (2013). |

DECIMAL | DECIMAL | Converts a text representation of a number in a given base into a decimal number (2013). |

DEGREES | DEGRES | Converts radians to degrees. |

EVEN | PAIR | Rounds a number up to the nearest even integer. |

EXP | EXP | Returns e raised to the power of a given number. |

FACT | FACT | Returns the factorial of a number. |

FACTDOUBLE | FACTDOUBLE | Returns the double factorial of a number. |

FLOOR | PLANCHER | Rounds a number down, toward zero. |

FLOOR.MATH | PLANCHER.MATH | Rounds a number down, to the nearest integer or to the nearest multiple of significance (2013). |

FLOOR.PRECISE | PLANCHER.PRECIS | Rounds a numer down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.. |

GCD | PGCD | Returns the greatest common divisor. |

INT | ENT | Rounds a number down to the nearest integer. |

LCM | PPCM | Returns the least common multiple. |

LN | LN | Returns the natural logarithm of a number. |

LOG | LOG | Returns the logarithm of a number to a specified base. |

LOG10 | LOG10 | Returns the base-10 logarithm of a number. |

Functions in English | Functions in French | Description of Function |
---|---|---|

MDETERM | DETERMAT | Returns the matrix determinant of an array. |

MINVERSE | INVERSEMAT | Returns the matrix inverse of an array. |

MMULT | PRODUITMAT | Returns the matrix product of two arrays. |

MOD | MOD | Returns the remainder from division. |

MROUND | ARRONDI.AU.MULTIPLE | Returns a number rounded to the desired multiple. |

MULTINOMIAL | MULTINOMIALE | Returns the multinomial of a set of numbers. |

MUNIT | MATRICE.UNITAIRE | Returns the unit matrix or the specified dimension (2013). |

ODD | IMPAIR | Rounds a number up to the nearest odd integer. |

PI | PI | Returns the value of pi. |

POWER | PUISSANCE | Returns the result of a number raised to a power. |

PRODUCT | PRODUIT | Multiplies its arguments. |

QUOTIENT | QUOTIENT | Returns the integer portion of a division. |

RADIANS | RADIANS | Converts degrees to radians. |

RAND | ALEA | Returns a random number between 0 and 1. |

RANDARRAY | TABLEAU.ALEAT | Returns an array of random numbers (365). |

RANDBETWEEN | ALEA.ENTRE.BORNES | Returns a random number between the numbers you specify. |

ROMAN | ROMAIN | Converts an arabic numeral to roman, as text. |

ROUND | ARRONDI | Rounds a number to a specified number of digits. |

ROUNDDOWN | ARRONDI.INF | Rounds a number down, toward zero. |

ROUNDUP | ARRONDI.SUP | Rounds a number up, away from zero. |

SEC | SEC | Returns the secant of an angle (2013). |

SECH | SECH | Returns the hyperbolic secant of an angle (2013). |

SEQUENCE | SEQUENCE | Generate a list of sequential numbers in an array (365). |

SERIESSUM | SOMME.SERIES | Returns the sum of a power series based on the formula. |

SIGN | SIGNE | Returns the sign of a number. |

SIN | SIN | Returns the sine of the given angle. |

SINH | SINH | Returns the hyperbolic sine of a number. |

SQRT | RACINE | Returns a positive square root. |

SQRTPI | RACINE.PI | Returns the square root of (number * pi). |

SUBTOTAL | SOUS.TOTAL | Returns a subtotal in a list or database. |

SUM | SOMME | Adds its arguments. |

SUMIF | SOMME.SI | Adds the cells specified by a given criteria. |

SUMIFS | SOMME.SI.ENS | Adds the cells in a range that meet multiple criteria. |

SUMPRODUCT | SOMMEPROD | Returns the sum of the products of corresponding array components. |

SUMSQ | SOMME.CARRES | Returns the sum of the squares of the arguments. |

SUMX2MY2 | SOMME.X2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays. |

SUMX2PY2 | SOMME.X2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays. |

SUMXMY2 | SOMME.XMY2 | Returns the sum of squares of differences of corresponding values in two arrays. |

TAN | TAN | Returns the tangent of a number. |

TANH | TANH | Returns the hyperbolic tangent of a number. |

TRUNC | TRONQUE | Truncates a number to an integer. |