Calculating percentages

[Guest]

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?

 

[Guest]

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

 

[SteveG]

Try

=(B2-A2)/ABS(A2)

This will give you the variance if A2 is last year and B2 is this year.
Format as percentage. So if last years sales was say 500,000 and this
years 100,000 then there is a decrease in sales of 60% so -60% is the
result of the formula. Vice versa, if last years sales were 200,000
and this years 500,000 then the formula shows the increase as 150%.


Cheers,

Steve