Excel Function Reference

Functions alphabetically | Functions by category

Functions are sorted from A to Z, click on a letter to quickly navigate in the table below.

Click on a link to get more detailed information about a function.

CONCAT function Concatenates values from multiple cells. Text
CONCATENATE function Joins text strings. Text
CONFIDENCE function Calculates the confidence interval for a population mean, using a normal distribution. Compatibility
CONFIDENCE.NORM function Calculates the confidence interval for a population mean. Statistical
CONFIDENCE.T function Calculates the confidence range for a population mean using a Student's t distribution. Statistical
CONVERT function Converts a number from one measurement system to another. Engineering
CORREL function Calculates the correlation between two groups of numbers. Statistical
COS function Calculates the cosine of an angle. Math and trigonometry
COSH function Calculates the hyperbolic cosine of a number. Math and trigonometry
COT function Calculates the cotangent of an angle specified in radians. Math and trigonometry
COTH function Calculates the hyperbolic cotangent of a hyperbolic angle. Math and trigonometry
COUNT function Counts all numerical values in an argument. Statistical
COUNTA function Counts the non-empty or blank cells in a cell range. Statistical
COUNTBLANK function Counts empty or blank cells in a range. Statistical
COUNTIF function Calculates the number of cells that is equal to a condition. Statistical
COUNTIFS function Calculates the number of cells across multiple ranges that equals all given conditions. Statistical
COVAR function Calculates the covariance meaning the average of the products of deviations for each pair in two different datasets. Compatibility
COVARIANCE.P function Calculates the covariance meaning the average of the products of deviations for each pair in two different datasets. Statistical
COVARIANCE.S function Calculates the sample covariance meaning the average of the products of deviations for each pair in two different datasets. Statistical
CRITBINOM function Compatibility
CSC function Calculates the cosecant of an angle (radians). Math and trigonometry
CUMIPMT function Calculates the accumulated interest based on a start and end period on a loan. Financial
CUMPRINC function Calculates the accumulated principal based on a start and end period on a loan. Financial
DATE function Returns a number that acts as a date in the Excel environment. Date and Time
DATEDIF function Returns the number of days, months, or years between two dates. The DATEDIF function exists in order to ensure compatibility with Louts 1-2-3. Date and Time
DATEVALUE function Returns an Excel date value (serial number) based on a date stored as text. Date and Time
DAVERAGE function Calculates an average based on values in a list or database that meet specific conditions. Database
DAY function Extracts the day as a number from an Excel date. Date and Time
DAYS function Calculates the number of days between two dates. Date and Time
DB function Calculates the depreciation of an asset for a given period using the fixed-declining balance method. Financial
DCOUNT function Counts cells containing numbers and that meet a condition or criteria. Database

Back to top