Fonctions Math & Trig

[ ] indicates optional parameters

ABS(nombre)
ACOS(nombre)
ACOSH(nombre)
ALEA()
ALEA.ENTRE.BORNES(smallest; largest)
ARRONDI(nombre; no_chiffres)
ARRONDI.AU.MULTIPLE(nombre; multiple)
ARRONDI.INF(nombre; [no_chiffres])
ARRONDI.SUP(nombre; [no_chiffres])
ASIN(nombre)
ASINH(nombre)
ATAN(nombre)
ATAN2(x_num; y_num)
ATANH(nombre)
COMBIN(nombre_éléments; nb_éléments_choisis)
COS(nombre)
COSH(nombre)
DEGRES(angle)
DETERMAT(plage)
ENT(nombre)
EXP(nombre)
FACT(nombre)
IMPAIR(nombre)
INVERSEMAT(plage)
LN(nombre)
LOG(nombre; [base])
LOG10(nombre)
MOD(nombre; diviseur)
MULTINOMIALE(nombre1; [nombre2; ...])
NB.SI(plage; critères)
PAIR(nombre)
PGCD(nombre1; [nombre2; ...])
PI()
PLAFOND(nombre; précision)
PLANCHER(nombre; précision)
PPCM(nombre1; [nombre2; ...])
PRODUIT(nombre1; [nombre2; ...])
PRODUITMAT(plage1; plage2)
PUISSANCE(nombre; puissance)
QUOTIENT(numerator; denominator)
RACINE(nombre)
RACINE.PI(nombre)
RADIANS(angle)
ROMAIN(nombre; [type])
SIGNE(nombre)
SIN(nombre)
SINH(nombre)
SOMME(nombre1; [nombre2; ...])
SOMME.CARRES(nombre1; [nombre2; ...])
SOMME.SERIES(x; n; m; coefficients)
SOMME.SI(plage; critère; [somme_plage])
SOMME.X2MY2(matrice_x; matrice_y)
SOMME.X2PY2(matrice_x; matrice_y)
SOMME.XMY2(matrice_x; matrice_y)
SOMMEPROD(plage1; [plage2; ...])
SOUS.TOTAL(no_fonction; réf1; [réf2; ...])
TAN(nombre)
TANH(nombre)
TRONQUE(nombre; [no_chiffres])


Fonctions Math & Trig

ABS(nombre)

Returns the absolute value of a number.

nombreThe number for which you want the absolute value.


ACOS(nombre)

Returns the angle in radians corresponding to the arccosine of a number.

nombreThe number for which you want the arccosine.


ACOSH(nombre)

Returns the angle in radians corresponding to the inverse hyperbolic cosine of a number.

nombreThe number for which you want the inverse hyperbolic cosine.


ALEA()

Returns a random number between 0 and 1.



ALEA.ENTRE.BORNES(smallest; largest)

Returns a random integer in the range you specify.

smallestThe lower limit of the range.
largestThe upper limit of the range.


ARRONDI(nombre; no_chiffres)

Returns a number rounded to the number of decimal places specified.

nombreThe number that you want rounded.
no_chiffresThe number of decimal places to round to (may be negative).


ARRONDI.AU.MULTIPLE(nombre; multiple)

Returns the number rounded to a multiple.

nombreThe number that you want rounded.
multipleThe multiple to which you want the number rounded.


ARRONDI.INF(nombre; [no_chiffres])

Returns a number rounded down to the number of decimal places specified.

nombreThe number that you want rounded.
no_chiffresThe number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0.


ARRONDI.SUP(nombre; [no_chiffres])

Returns a number rounded up to the number of decimal places specified.

nombreThe number that you want rounded.
no_chiffresThe number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0.


ASIN(nombre)

Returns the angle in radians corresponding to the arcsine of a number.

nombreThe number for which you want the arcsine.


ASINH(nombre)

Returns the angle in radians corresponding to the inverse hyperbolic sine of a number.

nombreThe number for which you want the inverse hyperbolic sine.


ATAN(nombre)

Returns the angle in radians corresponding to the arctangent of a number.

nombreThe number for which you want the arctangent.


ATAN2(x_num; y_num)

Returns the angle in radians corresponding to a pair of co-ordinates.

x_numThe x co-ordinate for which you want the angle.
y_numThe y co-ordinate for which you want the angle.


ATANH(nombre)

Returns the angle in radians corresponding to the inverse hyperbolic tangent of a number.

nombreThe number for which you want the inverse hyperbolic tangent.


COMBIN(nombre_éléments; nb_éléments_choisis)

Returns the number of combinations in which a number of items can be chosen from a total number.

nombre_élémentsThe total number of items.
nb_éléments_choisisThe number of items chosen.


COS(nombre)

Returns the cosine of an angle.

nombreThe angle for which you want the cosine. It must be specified in radians.


COSH(nombre)

Returns the hyperbolic cosine of an angle.

nombreThe angle for which you want the hyperbolic cosine. It must be specified in radians.


DEGRES(angle)

Converts an angle from radians to degrees.

angleThe angle that you want to convert.


DETERMAT(plage)

Returns the determinant of a matrix.

plageAn array or reference to cells containing the matrix.


ENT(nombre)

Returns the number rounded down to the next integer.

nombreThe number which you want rounded.


EXP(nombre)

Returns the e raised to the power number.

nombreThe power to which you want to raise e.


FACT(nombre)

Returns the factorial of a number.

nombreThe number of which you want the factorial.


IMPAIR(nombre)

Returns the number rounded up to the next odd number.

nombreThe number which you want rounded.


INVERSEMAT(plage)

Returns the inverse of a matrix.

plageAn array or reference to cells containing the matrix.


LN(nombre)

Returns the natural logarithm of a number.

nombreThe number for which you want the natural logarithm.


LOG(nombre; [base])

Returns the logarithm of a number in a specified base.

nombreThe number for which you want the logarithm.
baseThe base in which you want the logarithm. If this parameter is omitted it defaults to 10.


LOG10(nombre)

Returns the base 10 logarithm of a number.

nombreThe number for which you want the base 10 logarithm.


MOD(nombre; diviseur)

Returns the remainder of a division.

nombreThe dividend.
diviseurThe divisor.


MULTINOMIALE(nombre1; [nombre2; ...])

Returns the factorial of the sum of the values divided by the product of their factorials.

nombre1; ...The numbers of which you want the multinomial.


NB.SI(plage; critères)

Returns the number of cells in a specified range that meet the specified criteria.

plageA reference to the cells you want to count.
critèresA string containing a comparison expression.


PAIR(nombre)

Returns the number rounded up to the next even number.

nombreThe number which you want rounded.


PGCD(nombre1; [nombre2; ...])

Returns the greatest common divisor of a set of numbers.

nombre1; ...The numbers of which you want the greatest common divisor.


PI()

Returns the value of Pi.



PLAFOND(nombre; précision)

Returns the number rounded up (away from zero) to the next multiple of significance.

nombreThe number which you want rounded.
précisionThe units you want to use for rounding.


PLANCHER(nombre; précision)

Returns the number rounded down (towards zero) to the next multiple of significance.

nombreThe number which you want rounded.
précisionThe units you want to use for rounding.


PPCM(nombre1; [nombre2; ...])

Returns the lowest common multiple of a set of numbers.

nombre1; ...The numbers of which you want the lowest common multiple.


PRODUIT(nombre1; [nombre2; ...])

Returns the product of a list of numbers.

nombre1; ...The numbers that you want to multiply together.


PRODUITMAT(plage1; plage2)

Returns the product of two matrices.

plage1An array or reference to cells containing the first matrix.
plage2An array or reference to cells containing the second matrix.


PUISSANCE(nombre; puissance)

Returns the number raised to the power.

nombreThe number which you want raised to a power.
puissanceThe power to which you want to raise the number.


QUOTIENT(numerator; denominator)

Returns the integer result of a division.

numeratorThe dividend.
denominatorThe divisor.


RACINE(nombre)

Returns the square root of a number.

nombreThe number of which you want the square root.


RACINE.PI(nombre)

Returns the square root of a number after it is multiplied by Pi.

nombreThe number which you want to multiply by Pi and then take the square root.


RADIANS(angle)

Converts an angle from degrees to radians.

angleThe angle that you want to convert.


ROMAIN(nombre; [type])

Returns a string representing a number converted to roman numerals.

nombreThe number that you want to convert.
typeSpecifies the compactness of the representation. The possible values are:
0Classic
1More compact
2More compact
3More compact
4Simplified
VRAIClassic
FAUXSimplified
If this parameter is omitted it defaults to 0.


SIGNE(nombre)

Returns the sign of a number; 1 for positive, -1 for negative and 0 for zero.

nombreThe number of which you want the sign.


SIN(nombre)

Returns the sine of an angle.

nombreThe angle for which you want the sine. It must be specified in radians.


SINH(nombre)

Returns the hyperbolic sine of an angle.

nombreThe angle for which you want the hyperbolic sine. It must be specified in radians.


SOMME(nombre1; [nombre2; ...])

Returns the sum of a list of numbers.

nombre1; ...The numbers that you want to add together.


SOMME.CARRES(nombre1; [nombre2; ...])

Returns the sum of the squares of the numbers in the list.

nombre1; ...The numbers that are to be squared and then summed.


SOMME.SERIES(x; n; m; coefficients)

Returns the value of a polynomial.

xThe number to be raised to a power.
nThe power of the first term in the series.
mThe difference between successive powers in the series.
coefficientsAn array or reference to cells containing the coefficients.


SOMME.SI(plage; critère; [somme_plage])

Returns the sum of cells in a specified range that meet the specified criteria.

plageA reference to the cells you want to check.
critèreA string containing a comparison expression.
somme_plageA range containing values to be summed where the values in the first range meet the specified criteria. If this parameter is omitted then the values in the first range are summed.


SOMME.X2MY2(matrice_x; matrice_y)

Returns the sum of the differences of the squares of the numbers in the ranges.

matrice_xThe first range of numbers.
matrice_yThe second range of numbers.


SOMME.X2PY2(matrice_x; matrice_y)

Returns the sum of the sums of the squares of the numbers in the ranges.

matrice_xThe first range of numbers.
matrice_yThe second range of numbers.


SOMME.XMY2(matrice_x; matrice_y)

Returns the sum of the squares of the differences of the numbers in the ranges.

matrice_xThe first range of numbers.
matrice_yThe second range of numbers.


SOMMEPROD(plage1; [plage2; ...])

Returns the sum of the products of the cells in one or more ranges.

plage1; ...The ranges of cells where corresponding values are multiplied together and then summed.


SOUS.TOTAL(no_fonction; réf1; [réf2; ...])

Returns the subtotal of values in one or more ranges, excluding other subtotal figures.

no_fonctionThe subtotal function that you want. The possible values are:
1MOYENNE
2NB
3NBVAL
4MAX
5MIN
6PRODUIT
7ECARTYPE
8ECARTYPEP
9SOMME
10VAR
11VAR.P
réf1; ...The ranges of cells that you want subtotalled.


TAN(nombre)

Returns the tangent of an angle.

nombreThe angle for which you want the tangent. It must be specified in radians.


TANH(nombre)

Returns the hyperbolic tangent of an angle.

nombreThe angle for which you want the hyperbolic tangent. It must be specified in radians.


TRONQUE(nombre; [no_chiffres])

Returns a number truncated to the number of decimal places specified.

nombreThe number that you want truncated.
no_chiffresThe number of decimal places to truncate to (may be negative).