Q:

How do you calculate percentage change in Excel?

A:

Quick Answer

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 enter into the document. Assuming the two numbers for which you want to find the percentage change are in cells A2 and B2, the formula to use would be =(B2/A2)-1.

Know More

Keep Learning

Full Answer

For example, let's assume your salary in your first year of employment at a job were \$40,000 and your salary in your second year of employment at the same job were \$50,000. If you were to enter 40,000 into cell A2 and 50,000 into cell B2, you would then select an empty cell on the Excel document and enter the following formula into that cell: =50,000/40,000)-1.

The percentage change in salary from the first year to the second year will appear in the cell as a decimal. To change the decimal to a percentage, right click the cell and choose "Format Cells" from the drop-down menu. When the dialog box opens, choose "Percentage" from the list, then click "OK."

Repeat this process as many times as needed with other numbers for which you want to find the percentage change.

Learn more about Software
Sources:

Related Questions

• A:

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 have a specific SUBTRACT function.

Full Answer >
Filed Under:
• A:

In Excel, the mean function is used to calculate the average of a set of numbers. The numbers used can come from any cell in an Excel spreadsheet by listing the cells involved into the average function box.

Full Answer >
Filed Under:
• A:

To create a tick box in Excel, view the Developer tab, click on Insert, select Check Box under Form Controls, and on the worksheet, click on the location of the check box. To specify the properties, right-click on the check box, and select Format Control.

Full Answer >
Filed Under:
• A:

Microsoft Office Training and Tutorials offers several free training courses and videos to learn Excel. As of 2015, it offers learning materials for the 2007, 2010 and 2013 versions of Excel. In addition, free courses for learning mobile, online and Mac versions of Excel are available.

Full Answer >
Filed Under: