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.

Continue Reading

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

Related Questions

  • Q:

    What are some free online Excel courses?

    A:

    Microsoft and GCF Learn Free offer free online courses for Excel. Whereas the training center by Microsoft has courses for Windows, Mac OS X, Android, iOS and Windows Phone platforms, GCF Learn Free only offers courses for the Windows edition of the program.

    Full Answer >
    Filed Under:
  • Q:

    How can you get a free trial of Excel?

    A:

    Microsoft offers a free trial of its Office 365 software suite, which includes the Excel application, on Office.com. You need a Microsoft account to download the free trial.

    Full Answer >
    Filed Under:
  • Q:

    How do you create a schedule in Excel?

    A:

    Free schedule templates are available for download from Microsoft's official website to begin creating schedules in Excel. Ensure the template is compatible with the computer's current version of Windows before performing the download.

    Full Answer >
    Filed Under:
  • Q:

    Does Microsoft offer help for learning Excel?

    A:

    As of 2015, Microsoft provides training courses, tutorials and links to videos for beginner, intermediate and advanced users of the spreadsheet application Excel 2013. This application is part of the Microsoft Office suite, which is a collection of productivity programs developed by the company.

    Full Answer >
    Filed Under:

Explore