| Functions in English | Functions in French | Description of Function |
|---|
| BETADIST | LOI.BETA | Returns the beta cumulative distribution function. |
| BETAINV | BETA.INVERSE | Returns the inverse of the cumulative distribution function for a specified beta distribution. |
| BINOMDIST | LOI.BINOMIALE | Returns the individual term binomial distribution probability. |
| CEILING | PLAFOND | Rounds a number to the nearest integer or to the nearest multiple of significance. |
| CHIDIST | LOI.KHIDEUX | Returns the one-tailed probability of the chi-squared distribution. |
| CHIINV | KHIDEUX.INVERSE | Returns the inverse of the one-tailed probability of the chi-squared distribution. |
| CHITEST | TEST.KHIDEUX | Returns the test for independence. |
| CONCATENATE | CONCATENER | Joins several text items into one text item. |
| CONFIDENCE | INTERVALLE.CONFIANCE | Returns the confidence interval for a population mean. |
| COVAR | COVARIANCE | Returns covariance, the average of the products of paired deviations. |
| CRITBINOM | CRITERE.LOI.BINOMIALE | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |
| EXPONDIST | LOI.EXPONENTIELLE | Returns the exponential distribution. |
| FDIST | LOI.F | Returns the F probability distribution. |
| FINV | INVERSE.LOI.F | Returns the inverse of the F probability distribution. |
| FLOOR | PLANCHER | Rounds a number down, toward zero. |
| FORECAST | PREVISION | Returns a value along a linear trend. |
| FTEST | TEST.F | Returns the result of an F-test. |
| GAMMADIST | LOI.GAMMA | Returns the gamma distribution. |
| GAMMAINV | LOI.GAMMA.INVERSE | Returns the inverse of the gamma cumulative distribution. |
| HYPGEOMDIST | LOI.HYPERGEOMETRIQUE | Returns the hypergeometric distribution. |
| LOGINV | LOI.LOGNORMALE.INVERSE | Returns the inverse of the lognormal cumulative distribution function. |
| LOGNORMDIST | LOI.LOGNORMALE | Returns the cumulative lognormal distribution. |
| Functions in English | Functions in French | Description of Function |
|---|
| MODE | MODE | Returns the most common value in a data set. |
| NEGBINOMDIST | LOI.BINOMIALE.NEG | Returns the negative binomial distribution. |
| NORMDIST | LOI.NORMALE | Returns the normal cumulative distribution. |
| NORMINV | LOI.NORMALE.INVERSE | Returns the inverse of the normal cumulative distribution. |
| NORMSDIST | LOI.NORMALE.STANDARD | Returns the standard normal cumulative distribution. |
| NORMSINV | LOI.NORMALE.STANDARD.INVERSE | Returns the inverse of the standard normal cumulative distribution. |
| PERCENTILE | CENTILE | Returns the k-th percentile of values in a range. |
| PERCENTRANK | RANG.POURCENTAGE | Returns the percentage rank of a value in a data set. |
| POISSON | LOI.POISSON | Returns the Poisson distribution. |
| QUARTILE | QUARTILE | Returns the quartile of a data set. |
| RANK | RANG | Returns the rank of a number in a list of numbers. |
| STDEV | ECARTYPE | Estimates standard deviation based on a sample. |
| STDEVP | ECARTYPEP | Calculates standard deviation based on the entire population. |
| TDIST | LOI.STUDENT | Returns the Student's t-distribution. |
| TINV | LOI.STUDENT.INVERSE | Returns the inverse of the Student's t-distribution. |
| TTEST | TEST.STUDENT | Returns the probability associated with a Student's t-test. |
| VAR | VAR | Estimates variance based on a sample. |
| VARP | VAR.P | Calculates variance based on the entire population. |
| WEIBULL | LOI.WEIBULL | Returns the Weibull distribution. |
| ZTEST | TEST.Z | Returns the one-tailed probability-value of a z-test. |