Thread: How do I calculate year vs. year sales in a percentage?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default How do I calculate year vs. year sales in a percentage?
=(1200/1000)-1 = 20%

Dave
--
Brevity is the soul of wit.


"johngalt" wrote:

For example.

Fiscal year 06 sales of 1000
fiscal year 07 sales 1200
07 vs 06 sales are up x%
Reply With QuoteReply With Quote