ExcelBanter - % Change

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - % Change (https://www.excelbanter.com/excel-discussion-misc-queries/230254-%25-change.html)

Nerdy Girl

% Change

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

Domenic[_2_]

% 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

All times are GMT +1. The time now is 02:33 AM.