| Functions in English | Functions in French | Description of Function |
|---|
| AVEDEV | ECART.MOYEN | Returns the average of the absolute deviations of data points from their mean. |
| AVERAGE | MOYENNE | Returns the average of its arguments. |
| AVERAGEA | AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values. |
| AVERAGEIF | MOYENNE.SI | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. |
| AVERAGEIFS | MOYENNE.SI.ENS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
| BETA.DIST | LOI.BETA.N | Returns the beta cumulative distribution function. |
| BETA.INV | BETA.INVERSE.N | Returns the inverse of the cumulative distribution function for a specified beta distribution. |
| BINOM.DIST | LOI.BINOMIALE.N | Returns the individual term binomial distribution probability. |
| BINOM.DIST.RANGE | LOI.BINOMIALE.SERIE | Returns the probability of a trial result using a binomial distribution (2013). |
| BINOM.INV | LOI.BINOMIALE.INVERSE | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |
| CHISQ.DIST | LOI.KHIDEUX.N | Returns the cumulative beta probability density function. |
| CHISQ.DIST.RT | LOI.KHIDEUX.DROITE | Returns the one-tailed probability of the chi-squared distribution. |
| CHISQ.INV | LOI.KHIDEUX.INVERSE | Returns the cumulative beta probability density function. |
| CHISQ.INV.RT | LOI.KHIDEUX.INVERSE.DROITE | Returns the inverse of the one-tailed probability of the chi-squared distribution. |
| CHISQ.TEST | CHISQ.TEST | Returns the test for independence. |
| CONFIDENCE.NORM | INTERVALLE.CONFIANCE.NORMAL | Returns the confidence interval for a population mean. |
| CONFIDENCE.T | INTERVALLE.CONFIANCE.STUDENT | Returns the confidence interval for a population mean, using a Student's t distribution. |
| CORREL | COEFFICIENT.CORRELATION | Returns the correlation coefficient between two data sets. |
| Functions in English | Functions in French | Description of Function |
|---|
| COUNT | NB | Counts how many numbers are in the list of arguments. |
| COUNTA | NBVAL | Counts how many values are in the list of arguments. |
| COUNTBLANK | NB.VIDE | Counts the number of blank cells within a range. |
| COUNTIF | NB.SI | Counts the number of cells within a range that meet the given criteria. |
| COUNTIFS | NB.SI.ENS | Counts the number of cells within a range that meet multiple criteria. |
| COVARIANCE.P | COVARIANCE.PEARSON | Returns covariance, the average of the products of paired deviations. |
| COVARIANCE.S | COVARIANCE.STANDARD | Returns the sample covariance, the average of the products deviations for each data point pair in two data sets. |
| DEVSQ | SOMME.CARRES.ECARTS | Returns the sum of squares of deviations. |
| EXPON.DIST | LOI.EXPONENTIELLE.N | Returns the exponential distribution. |
| F.DIST | LOI.F.N | Returns the F probability distribution. |
| F.DIST.RT | LOI.F.DROITE | Returns the F probability distribution. |
| F.INV | INVERSE.LOI.F.N | Returns the inverse of the F probability distribution. |
| F.INV.RT | INVERSE.LOI.F.DROITE | Returns the inverse of the F probability distribution. |
| F.TEST | F.TEST | Returns the result of an F-test. |
| FISHER | FISHER | Returns the Fisher transformation. |
| FISHERINV | FISHER.INVERSE | Returns the inverse of the Fisher transformation. |
| FORECAST.ETS | PREVISION.ETS | Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm (2016). |
| FORECAST.ETS.CONFINT | PREVISION.ETS.CONFINT | Returns a confidence interval for the forecast value at the specified target date (2016). |
| FORECAST.ETS.SEASONALITY | PREVISION.ETS.CARACTERESAISONNIER | Returns the length of the repetitive pattern Excel detects for the specified time series (2016). |
| FORECAST.ETS.STAT | PREVISION.ETS.STAT | Returns a statistical value as a result of time series forecasting (2016). |
| FORECAST.LINEAR | PREVISION.LINEAIRE | Returns a future value based on existing values (2016). |
| FREQUENCY | FREQUENCE | Returns a frequency distribution as a vertical array. |
| GAMMA | GAMMA | Returns the Gamma function value (2013). |
| GAMMA.DIST | LOI.GAMMA.N | Returns the gamma distribution. |
| GAMMA.INV | LOI.GAMMA.INVERSE.N | Returns the inverse of the gamma cumulative distribution. |
| GAMMALN | LNGAMMA | Returns the natural logarithm of the gamma function, G(x). |
| GAMMALN.PRECISE | LNGAMMA.PRECIS | Returns the natural logarithm of the gamma function, G(x). |
| GAUSS | GAUSS | Returns 0.5 less than the standard normal cumulative distribution (2013). |
| GEOMEAN | MOYENNE.GEOMETRIQUE | Returns the geometric mean. |
| GROWTH | CROISSANCE | Returns values along an exponential trend. |
| HARMEAN | MOYENNE.HARMONIQUE | Returns the harmonic mean. |
| HYPGEOM.DIST | LOI.HYPERGEOMETRIQUE.N | Returns the hypergeometric distribution. |
| INTERCEPT | ORDONNEE.ORIGINE | Returns the intercept of the linear regression line. |
| KURT | KURTOSIS | Returns the kurtosis of a data set. |
| LARGE | GRANDE.VALEUR | Returns the k-th largest value in a data set. |
| LINEST | DROITEREG | Returns the parameters of a linear trend. |
| LOGEST | LOGREG | Returns the parameters of an exponential trend. |
| LOGNORM.DIST | LOI.LOGNORMALE.N | Returns the cumulative lognormal distribution. |
| LOGNORM.INV | LOI.LOGNORMALE.INVERSE.N | Returns the inverse of the lognormal cumulative distribution. |
| MAX | MAX | Returns the maximum value in a list of arguments. |
| MAXA | MAXA | Returns the maximum value in a list of arguments, including numbers, text, and logical values. |
| MAXIFS | MAX.SI.ENS | Returns the maximum value among cells specified by a given set of conditions or criteria (2019). |
| MEDIAN | MEDIANE | Returns the median of the given numbers. |
| MIN | MIN | Returns the minimum value in a list of arguments. |
| MINA | MINA | Returns the smallest value in a list of arguments, including numbers, text, and logical values. |
| MINIFS | MIN.SI.ENS | Returns the minimum value among cells specified by a given set of conditions or criteria (2019). |
| MODE.MULT | MODE.MULTIPLE | Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. |
| MODE.SNGL | MODE.SIMPLE | Returns the most common value in a data set. |
| NEGBINOM.DIST | LOI.BINOMIALE.NEG.N | Returns the negative binomial distribution. |
| NORM.DIST | LOI.NORMALE.N | Returns the normal cumulative distribution. |
| NORM.INV | LOI.NORMALE.INVERSE.N | Returns the inverse of the normal cumulative distribution. |
| NORM.S.DIST | LOI.NORMALE.STANDARD.N | Returns the standard normal cumulative distribution. |
| NORM.S.INV | LOI.NORMALE.STANDARD.INVERSE.N | Returns the inverse of the standard normal cumulative distribution. |
| Functions in English | Functions in French | Description of Function |
|---|
| PEARSON | PEARSON | Returns the Pearson product moment correlation coefficient. |
| PERCENTILE.EXC | CENTILE.EXCLURE | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.. |
| PERCENTILE.INC | CENTILE.INCLURE | Returns the k-th percentile of values in a range. |
| PERCENTRANK.EXC | RANG.POURCENTAGE.EXCLURE | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. |
| PERCENTRANK.INC | RANG.POURCENTAGE.INCLURE | Returns the percentage rank of a value in a data set. |
| PERMUT | PERMUTATION | Returns the number of permutations for a given number of objects. |
| PERMUTATIONA | PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (2013). |
| PHI | PHI | Returns the value of the density function for a standard normal distribution (2013). |
| POISSON.DIST | LOI.POISSON.N | Returns the Poisson distribution. |
| PROB | PROBABILITE | Returns the probability that values in a range are between two limits. |
| QUARTILE.EXC | QUARTILE.EXCLURE | Returns the quartile of the data set, based on percentile values from 0..1, exclusive. |
| QUARTILE.INC | QUARTILE.INCLURE | Returns the quartile of a data set. |
| RANK.AVG | MOYENNE.RANG | Returns the rank of a number in a list of numbers. |
| RANK.EQ | EQUATION.RANG | Returns the rank of a number in a list of numbers. |
| RSQ | COEFFICIENT.DETERMINATION | Returns the square of the Pearson product moment correlation coefficient. |
| SKEW | COEFFICIENT.ASYMETRIE | Returns the skewness of a distribution. |
| SKEW.P | COEFFICIENT.ASYMETRIE.P | Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean (2013). |
| SLOPE | PENTE | Returns the slope of the linear regression line. |
| SMALL | PETITE.VALEUR | Returns the k-th smallest value in a data set. |
| STANDARDIZE | CENTREE.REDUITE | Returns a normalized value. |
| STDEV.P | ECARTYPE.PEARSON | Calculates standard deviation based on the entire population. |
| STDEV.S | ECARTYPE.STANDARD | Estimates standard deviation based on a sample. |
| STDEVA | STDEVA | Estimates standard deviation based on a sample, including numbers, text, and logical values. |
| STDEVPA | STDEVPA | Calculates standard deviation based on the entire population, including numbers, text, and logical values. |
| STEYX | ERREUR.TYPE.XY | Returns the standard error of the predicted y-value for each x in the regression. |
| T.DIST | LOI.STUDENT.N | Returns the Percentage Points (probability) for the Student t-distribution. |
| T.DIST.2T | LOI.STUDENT.BILATERALE | Returns the Percentage Points (probability) for the Student t-distribution. |
| T.DIST.RT | LOI.STUDENT.DROITE | Returns the Student's t-distribution. |
| T.INV | LOI.STUDENT.INVERSE.N | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. |
| T.INV.2T | LOI.STUDENT.INVERSE.BILATERALE | Returns the inverse of the Student's t-distribution. |
| T.TEST | T.TEST | Returns the probability associated with a Student's t-test. |
| TREND | TENDANCE | Returns values along a linear trend. |
| TRIMMEAN | MOYENNE.REDUITE | Returns the mean of the interior of a data set. |
| VAR.P | VAR.P.N | Calculates variance based on the entire population. |
| VAR.S | VAR.S | Estimates variance based on a sample. |
| VARA | VARA | Estimates variance based on a sample, including numbers, text, and logical values. |
| VARPA | VARPA | Calculates variance based on the entire population, including numbers, text, and logical values. |
| WEIBULL.DIST | LOI.WEIBULL.N | Returns the Weibull distribution. |
| Z.TEST | Z.TEST | Returns the one-tailed probability-value of a z-test. |