View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Calculating percentages

If this year is in A2 and last year in B2, then this year's sales, as a
percent of last year's, is A2/B2 (formatted as a percent). The sales growth
is (A2-B2)/B2 (formatted as a percent).
HTH. --Bruce

"Yari" wrote:

I'm preparing a report in which I'm comparing this years sales to last years
sales... What formula can I use to calculate this percentage?