Exceljet

Quick, clean, and to the point

Excel 2003

The functions below are available Excel 2003 and later versions, including Excel 365.

Excel CONVERT function

The Excel CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, Fahrenheit to Celsius, gallons into liters, and for many other unit...

Excel COS function

The Excel COS function returns the cosine of an angle given in radians. To supply an angle to COS in degrees, use the RADIANS function to convert to radians.

Excel COSH function
The Excel COSH function returns the hyperbolic cosine of a number.
Excel COUNT function

The Excel COUNT function returns a count of values that are numbers. Numbers include negative numbers, percentages, dates, times, fractions, and formulas that return numbers. Empty cells and text values are ignored.

Excel COUNTA function

The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (""). COUNTA does not count empty cells.

Excel COUNTBLANK function

The Excel COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, spaces, etc. are not counted. Formulas that return empty text are counted.

Excel COUNTIF function

COUNTIF is an Excel function to count cells in a range that meet a single condition. COUNTIF can be used to count cells that contain dates, numbers, and text. The criteria used in COUNTIF supports logical...

Excel COUPDAYBS function
The Excel COUPDAYBS function returns the number of days from the beginning of the coupon period to the settlement date.
Excel COUPDAYS function
The Excel COUPDAYS function returns the number of days in a coupon period that includes the settlement date.
Excel COUPDAYSNC function
The Excel COUPDAYSNC function returns the number of days from the settlement date to the next coupon date.
Excel COUPNCD function
The Excel COUPNCD function returns the next coupon date after the settlement date.
Excel COUPNUM function

The Excel COUPNUM function returns the number of coupons, or interest payments, payable between the settlement date and maturity date.

Excel COUPPCD function
The Excel COUPPCD function returns the previous coupon date before the settlement date for a coupon bond.
Excel CUMIPMT function
The Excel CUMIPMT function is a financial function that returns the cumulative interest paid on a loan between a start period and an end period. You can use CUMIPMT to calculate and verify the total interest paid on a loan, or the interest paid...
Excel CUMPRINC function
The Excel CUMPRINC function is a financial function that returns the cumulative principal paid on a loan between a start period and an end period. You can use CUMPRINC to calculate and verify the total principal paid on a loan, or the principal paid...
Excel DATE function

The Excel DATE function creates a valid date from individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet.

Excel DATEDIF function

The Excel DATEDIF function returns the difference between two date values in years, months, or days. The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. For reasons unknown, it is only documented in Excel...

Excel DATEVALUE function

The Excel DATEVALUE function converts a date represented as a text string into a valid Excel date. For example, the formula =DATEVALUE("3/10/1975") returns a serial number (...

Excel DAVERAGE function

The Excel DAVERAGE function returns the average in a given field for records that match criteria.

Excel DAY function

The Excel DAY function returns the day of the month as a number between 1 to 31 from a given date. You can use the DAY function to extract a day number from a date into a cell. You can also use the DAY function to extract and feed a day value...

Excel DAYS360 function

The Excel DAYS360 function returns the number of days between two dates based on a 360-day year, where all months are assumed to have 30 days. For example, the formula =DAYS360("1-Jan-2021","31-Dec-2021") returns 360 days.

Excel DB function

The Excel DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method. The calculation is based on initial asset cost, salvage value, the number of periods over which the asset is depreciated...

Excel DCOUNT function

The Excel DCOUNT function counts matching records in a database using criteria and an optional field. When a field is provided DCOUNT will only count numeric values in the field. Use DCOUNTA...

Excel DCOUNTA function

The Excel DCOUNTA function counts matching records in a database using criteria and an optional field. When a field is provided, DCOUNTA counts both numeric and text values when the field value is not empty. Use...

Excel DDB function

The Excel DDB function returns the depreciation of an asset for a given period using the double-declining balance method or another method you specify by changing the factor argument.

Excel DEC2BIN function
The Excel DEC2BIN function converts a decimal number to its binary equivalent.
Excel DEC2HEX function
The Excel DEC2HEX function converts a decimal number to its hexadecimal equivalent.
Excel DEC2OCT function
The Excel DEC2OCT function converts a decimal number to its octal equivalent.
Excel DEGREES function
The Excel DEGREES function converts angles (expressed in radians) to degrees. For example, the formula =DEGREES(PI()) returns 180.
Excel DELTA function

The Excel DELTA function will test if two numeric values are equal. When values are equal, DELTA returns 1, otherwise, DELTA returns zero.

Pages