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?
|