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.
| CHITEST | Compatibility |
 |
Returns the test for independence |
| CHOOSE | Lookup and reference |
|
Chooses a value from a list of values |
| CLEAN | Text |
|
Removes all nonprintable characters from text |
| CODE | Text |
|
Returns a numeric code for the first character in a text string |
| COLUMN | Lookup and reference |
|
Returns the column number of a reference |
| COLUMNS | Lookup and reference |
|
Returns the number of columns in a reference |
| COMBIN | Math and trigonometry |
|
Returns the number of combinations for a given number of objects |
| COMBINA | Math and trigonometry |
|
Returns the number of combinations with repetitions for a given number of items |
| COMPLEX | Engineering |
|
Converts real and imaginary coefficients into a complex number |
| CONCAT | Text |
|
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. |
| CONCATENATE | Text |
|
Joins several text items into one text item |
| CONFIDENCE | Compatibility |
|
Returns the confidence interval for a population mean |
| CONFIDENCE.NORM | Statistical |
|
Returns the confidence interval for a population mean |
| CONFIDENCE.T | Statistical |
|
Returns the confidence interval for a population mean, using a Student's t distribution |
| CONVERT | Engineering |
|
Converts a number from one measurement system to another |
| CORREL | Statistical |
|
Returns the correlation coefficient between two data sets |
| COS | Math and trigonometry |
|
Returns the cosine of a number |
| COSH | Math and trigonometry |
|
Returns the hyperbolic cosine of a number |
| COT | Math and trigonometry |
|
Returns the hyperbolic cosine of a number |
| COTH | Math and trigonometry |
|
Returns the cotangent of an angle |