How do I calculate year vs. year sales in a percentage?

How do I calculate year vs. year sales in a percentage?

Post by RGF2ZSB » Fri, 12 Jan 2007 02:57:02


=(1200/1000)-1 = 20%

Dave
--
Brevity is the soul of wit.
 
 
 

How do I calculate year vs. year sales in a percentage?

Post by David Bidd » Fri, 12 Jan 2007 03:23:01

06 sales in A1, 07 sales in A2
For x, use the formula =(A2/A1)-1 and format as percentage.
Other options include =(A2-A1)/A1.
If you want to use the percentage value as a number in its own right in
further calculations (the number 20 in your case), then multiply the result
by 100.
--
David Biddulph