Thread: % Change
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Domenic[_2_] Domenic[_2_] is offline
external usenet poster
 
Posts: 265
Default % Change

In article ,
Nerdy Girl wrote:

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?



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

=(B2-A2)/A2

--
Domenic
http://www.xl-central.com