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

You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, subtract, multiply or divide cell values are entered directly in ... More »

www.reference.com Technology Software

Some simple Excel spreadsheet formulas include =SUM(c1+c2) for addition, =SUM(c1-c2) for subtraction, =SUM(c1*c2) for multiplication and =SUM(c1/c2) for division. The =AVERAGE(c1:c2) formula can provide the average value... 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

Use the built-in formula calculations in Excel to help calculate totals. Creating a column of totals allows users to see real-time totals as information is added and updated. More »

www.reference.com Technology Software

To subtract dates in Excel, simply enter the following formula: "=A3-A2", assuming that cells A3 and A2 contain the dates that need to be subtracted. This will output the difference between the two dates, expressed in da... 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