# How do you calculate growth percentage year over year?

*900,558*questions on

Wikianswers

We'll use 1969 and 1970 as years 1 and 2 respectively. Also, say we're looking at Revenue growth or loss.

Example 1 Year 1 Revenue 1000 Year 2 Revenue 250

Step 1. 250 - 1000 = -750 Step 2. -750/1000 = - .75 Step 3. Convert to % = - 75% (Negative = LOSS %)

Example 2 Year 1 Revenue 150 Year 2 Revenue 500

Step 1. 500 - 150 = 350 Step 2. 350/150 = 2.33 Step 3. Convert to % = 233% (Positive = GROWTH %)

In Excel, let's say you have last year's sales numbers in cell A1 and this year's numbers in cell A2. In cell A3, you want to calculate the year over year percentage change.

The formula in cell A3 would look like this (Current - Previous)/Previous or =SUM(A2-A1)/A1. Instead of multiplying by 100 to get the percent, use the "Format cell" option to choose percentage. The number will automatically change to a percentage.