## 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