| 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.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.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. |
| ISO.CEILING | ISO.PLAFOND | Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. |
| 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.ALEA | 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. |