The AMORDEGRC function returns the depreciation of an asset for a specified period using a depreciation coefficient from a table of depreciation coefficients.ĪMORDEGRC(cost, date_purchased, first_period, salvage, period, ) Formula:ĪMORDEGRC(10000, DATE(2015,1,1), DATE(2015,4,1), 1000, 12, 4)This example returns the depreciation of an asset with a cost of 10,000 purchased on January 1, 2015, with a first period ending on April 1, 2015, a salvage value of 1,000, a period of 12, and a depreciation coefficient of 4. This formula will calculate the average of the values in the range A1:A10. Ref1,, …: This is the range of cells that will be used for the calculation. Options: This is a number that specifies the options to be used.

on a range of data.ĪGGREGATE(function_num, options, ref1,, …) Function_num: This is a number that specifies the type of function to be used. The AGGREGATE function is a built-in function in Excel that performs calculations such as sum, count, average, max, min, product, etc. The ADDRESS function returns a cell address as text, based on a given row and column number.ĪDDRESS(row_num, column_num,, , ) Formula:ĪDDRESS(2,3,4,TRUE,”Sheet1″)This example will return the address of cell C4 (row 2, column 3) on Sheet1 as $C$4. The ACOTH function is an Excel function that returns the inverse hyperbolic cotangent of a given number.ĪCOTH(2)This formula returns 0.5493061443340548. The ACOT function returns the inverse cotangent (arccotangent) of a given number.ĪCOT(0.5)This formula returns 1.10714871779409. The ACOSH function returns the inverse hyperbolic cosine of a number.ĪCOSH(3)The result of this formula is 1.762747174039086. To find the arccosine of 0.5, the formula would be:=ACOS(0.5) The ACOS function returns the arccosine (in radians) of a number. The ACCRINTM function returns the amount of interest that has been accrued on a security that pays periodic interest, such as a bond, between a start and end date.ĪCCRINTM(issue, first_interest, settlement, rate, par, frequency,, ) Formula:ĪCCRINTM(“”, “”, “”, 0.06, 1000, 2, 0, 0)This example returns the amount of interest accrued on a bond with an issue date of, first interest date of, settlement date of, annual interest rate of 6%, par value of $1,000, and semi-annual frequency, using the US (NASD) 30/360 day count basis and the price basis method.

The basis and calculation method are both set to 0. The ACCRINT function in Microsoft Excel calculates the accrued interest for a security that pays periodic interest.ĪCCRINT(issue, first_interest, settlement, rate, par, frequency,, ) Formula:ĪCCRINT(“″,”″,””,0.05,1000,2,0,0)This example calculates the accrued interest for a security with an issue date of, first interest date of, settlement date of, interest rate of 5%, par value of 1000, and a frequency of 2 (semi-annually). The ABS function in Excel returns the absolute value of a number.

Microsoft excel formulas and functions