articles

The formula to calculate age in Excel is: =DATEDIF(CELLREF,TODAY(),"Y") & " Years, " & DATEDIF(CELLREF,TODAY(),"YM") & " Months, " & DATEDIF(CELLREF,TODAY(),"MD") & " Days". In this formula, replace "CELLREF" with the co... More »

www.reference.com Technology Software

The formula for calculating compound annual growth rate (CAGR) in Excel is: = ((FV/PV)^(1/n)) – 1, where "FV" is the ending value, "PV" is the beginning value and "n" is the number of years. CAGR is a measurement of the ... More »

www.reference.com Technology Software

To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula. More »

www.reference.com Technology Software
similar articles

To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not ... More »

www.reference.com Technology Software

Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is being determined. This range is either a row or a column of cell... More »

www.reference.com Technology Software

To calculate covariance in Excel, use the covariance function. The syntax of the function is: COVARIANCE.P(array1,array2), where array1 and array2 are the two sets of data for which the covariance is being determined. More »

www.reference.com Technology Software

Microsoft Excel does not have an automatic function that allows you to calculate percentage change. Despite this, you can find the percentage change between two numbers in a spreadsheet if you know the proper formula to ... More »

www.reference.com Technology Software