% Change

  • Thread starter Thread starter Nerdy Girl
  • Start date Start date
N

Nerdy Girl

How can I show the percentage of change from one amount to the next, e.g. the
percentage of change from one year's payroll totals to the next?
 
Nerdy Girl said:
How can I show the percentage of change from one amount to the next, e.g. the
percentage of change from one year's payroll totals to the next?
Click to expand...


Assuming that A2 contains the first year's total, and B2 contains the
second year's total, try...

=(B2-A2)/A2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Epic Games freebies 2
how to change percentage symbol (Excel XP) 1
Change all of the cells in a row(s) by a percentage 4
Challenging the GOAL SEEK function within a bonus scheme 6
Payroll tax deductions 4
Pivot Table percentages 1
Percentage Formula 6
If statement with multiple criteria and multiple results 3

Back
Top