Excel

[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

 

[J.E. McGimpsey]

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

 

[Lmiller048]

I just wanted to say thank you. It worked perfectly.
Again, JE, thank you.