Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture.
| Function | Description |
| BETADIST function | Returns the beta cumulative distribution function |
| BETAINV function | Returns the inverse of the cumulative distribution function for a specified beta distribution |
| BINOMDIST function | Returns the individual term binomial distribution probability |
| CHIDIST function | Returns the one-tailed probability of the chi-squared distribution |
| CHIINV function | Returns the inverse of the one-tailed probability of the chi-squared distribution |
| CHITEST function | Returns the test for independence |
| CONCATENATE function | Joins two or more text strings into one string. |
| CONFIDENCE function | Returns the confidence interval for a population mean |
| COVAR function | Returns covariance, the average of the products of paired deviations |
| CRITBINOM function | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
| EXPONDIST function | Returns the exponential distribution |
| FDIST function | Returns the F probability distribution |
| FINV function | Returns the inverse of the F probability distribution |
| FORECAST function | Returns a value along a linear trend |
| Note: In Excel 2016, this function is replaced with the new Forecasting functions, but it’s still available for compatibility with earlier versions. | |
| FLOOR function | Rounds a number down, toward zero |
| FTEST function | Returns the result of an F-test |
| GAMMADIST function | Returns the gamma distribution |
| GAMMAINV function | Returns the inverse of the gamma cumulative distribution |
| HYPGEOMDIST function | Returns the hypergeometric distribution |
| LOGINV function | Returns the inverse of the lognormal cumulative distribution function |
| LOGNORMDIST function | Returns the cumulative lognormal distribution |
| MODE function | Returns the most common value in a data set |
| NEGBINOMDIST function | Returns the negative binomial distribution |
| NORMDIST function | Returns the normal cumulative distribution |
| NORMINV function | Returns the inverse of the normal cumulative distribution |
| NORMSDIST function | Returns the standard normal cumulative distribution |
| NORMSINV function | Returns the inverse of the standard normal cumulative distribution |
| PERCENTILE function | Returns the k-th percentile of values in a range |
| PERCENTRANK function | Returns the percentage rank of a value in a data set |
| POISSON function | Returns the Poisson distribution |
| QUARTILE function | Returns the quartile of a data set |
| RANK function | Returns the rank of a number in a list of numbers |
| STDEV function | Estimates standard deviation based on a sample |
| STDEVP function | Calculates standard deviation based on the entire population |
| TDIST function | Returns the Student’s t-distribution |
| TINV function | Returns the inverse of the Student’s t-distribution |
| TTEST function | Returns the probability associated with a Student’s t-test |
| VAR function | Estimates variance based on a sample |
| VARP function | Calculates variance based on the entire population |
| WEIBULL function | Returns the Weibull distribution |
| ZTEST function | Returns the one-tailed probability-value of a z-test |
Excel Fomulas PDF & Functions
A formulas in Excel is a mathematical expression that retures specific result. List of some useful Excel Formulas & Functions as Follows:
- = 1+ 3 // returns 4
- = 9 / 3 // returns 3
- = SUM(1,3,5) // returns 9
- = SUM(A1:A3) // returns A1+A2+A3
- = AVERAGE(3,4,5) //returns 6
- = MIN(2,5,4) // returns 2
- = MAX(2,5,4) // returns 5
- =COUNTIF (range, criteria) // two arguments
