Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
| BINOM.INV | Statistical |
 |
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
| BINOMDIST | Compatibility |
|
Returns the individual term binomial distribution probability |
| BITAND | Engineering |
|
Returns a 'Bitwise And' of two numbers |
| BITLSHIFT | Engineering |
|
Returns a value number shifted left by shift_amount bits |
| BITOR | Engineering |
|
Returns a bitwise OR of 2 numbers |
| BITRSHIFT | Engineering |
|
Returns a value number shifted right by shift_amount bits |
| BITXOR | Engineering |
|
Returns a bitwise 'Exclusive Or' of two numbers |
| CALL | Add-in and Automation |
|
Calls a procedure in a dynamic link library or code resource |
| CEILING | Math and trigonometry |
|
Rounds a number to the nearest integer or to the nearest multiple of significance |
| CEILING.MATH | Math and trigonometry |
|
Rounds a number up, to the nearest integer or to the nearest multiple of significance |
| CEILING.PRECISE | Math and trigonometry |
|
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. |
| CELL | Information |
|
Returns information about the formatting, location, or contents of a cell |
| CHAR | Text |
|
Returns the character specified by the code number |
| CHIDIST | Compatibility |
|
Returns the one-tailed probability of the chi-squared distribution |
| CHIINV | Compatibility |
|
Returns the inverse of the one-tailed probability of the chi-squared distribution |
| CHISQ.DIST | Statistical |
|
Returns the cumulative beta probability density function |
| CHISQ.DIST.RT | Statistical |
|
Returns the one-tailed probability of the chi-squared distribution |
| CHISQ.INV | Statistical |
|
Returns the cumulative beta probability density function |
| CHISQ.INV.RT | Statistical |
|
Returns the inverse of the one-tailed probability of the chi-squared distribution |
| CHISQ.TEST | Statistical |
|
Returns the test for independence |