Excel Functions

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.

Search

COUNT	Statistical		Counts how many numbers are in the list of arguments
COUNTA	Statistical		Counts how many values are in the list of arguments
COUNTBLANK	Statistical		Counts the number of blank cells within a range
COUNTIF	Statistical		Counts the number of cells within a range that meet the given criteria
COUNTIFS	Statistical		Counts the number of cells within a range that meet multiple criteria
COUPDAYBS	Financial		Returns the number of days from the beginning of the coupon period to the settlement date
COUPDAYS	Financial		Returns the number of days in the coupon period that contains the settlement date
COUPDAYSNC	Financial		Returns the number of days from the settlement date to the next coupon date
COUPNCD	Financial		Returns the next coupon date after the settlement date
COUPNUM	Financial		Returns the number of coupons payable between the settlement date and maturity date
COUPPCD	Financial		Returns the previous coupon date before the settlement date
COVAR	Compatibility		Returns covariance, the average of the products of paired deviations
COVARIANCE.P	Statistical		Returns covariance, the average of the products of paired deviations
COVARIANCE.S	Statistical		Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
CRITBINOM	Compatibility		Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CSC	Math and trigonometry		Returns the cosecant of an angle
CSCH	Math and trigonometry		Returns the hyperbolic cosecant of an angle
CUBEKPIMEMBER	Cube		Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.
CUBEMEMBER	Cube		Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
CUBEMEMBERPROPERTY	Cube		Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.