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
Reply With QuoteReply With Quote