Excel

  • Thread starter Thread starter Lmiller048
  • Start date Start date
L

Lmiller048

I'm putting together a spread sheet to show
the month % change. My columns run from Jan - Dec with a YTD column.

And I need to calculate the difference, can you help. I also need t
show Qtr % change
 
If january's data is in C1 and February's in E1, say, then the month
% change is

=E1/C1 - 1

formatted as a percentage.

Likewise, if March's data is in G1 and June's in M1, then the
quarterly % change is

=M1/G1 - 1

again, formatted as a percent
 
Back
Top