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