How to Calculate Decline with Excel

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows, Mac OS X, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Here is the instruction to tell you how to calculate decline with Excel.

QQ截图20150617171906
1. Isolate the figures for the period that you want to work with. For example, if you want the rate of decline for your sales over the last two months isolate your net sales for each month.

2. Create an Excel sheet that contains the sales figures for each month. Input each figure in a separate cell, either in the same column or the same row. For example, the first month in cell A1 and the second month in cell A2 for the same column or B1 for the same row.

3. Determine the amount of the difference between the two figures. Subtract the second month from the first month. For example, enter “=SUM(A2-A1)” in an empty cell, for example, cell C1.

4. Enter “=SUM(C1/A1)*100″ into cell D1 or another empty cell. The result of this calculation is your percentage or rate of decline.

  • Gregory Martin

    or in any cell “=((A2-A1)/A1)*100″ or format the cell that contains the calculation as a percentage and use “=(A2-A1)/A1″.