Best Answer

Enter 1st number in A1

Enter 2nd number in A2

In A3 enter =(1-A2/A1)*100

Or you can enter in A3 =(1-A2/A1) and format cell as number percentage

Q: How to calculate the percentage change between two numbers in excel?

Write your answer...

Submit

Still have questions?

Continue Learning about Math & Arithmetic

what is the percentage change from 92 to 86.5

You cannot. The starting value must be positive for a percentage change to make sense.

You do not. Percentage change (increase or decrease) makes sense only if both numbers are positive or both are negative. Consider the change from -50 to +50. You could calculate the percentage change as 100*(new-old)/old = -200% Now consider the percentage change from +50 to -50. -200% again! So, in percentage terms a change from +50 to -50 is the same as from -50 to +50.

you ask someone

To find A as a percentage of B, calculate 100*A/B To find A as a percentage change from B, calculate 100*(A/B -1) or, equivalently, 100*(A - B)/B. B should be positive else you will need great care in interpreting the result.

Related questions

To find the difference between the two numbers in percent form

(new-old)/old *100ORold/new-1

what is the percentage change from 92 to 86.5

Do not calculate percentage changes when the numbers are negative since they are extremely difficult to interpret. The change from +100 to -100 is -200% The change from -100 to +100 is also -200%. The percentage changes are the same but the underlying change is completely different.

You cannot. The starting value must be positive for a percentage change to make sense.

It istwo numbers are a percentage relationship between them orone number and a percentage change.

You calculate the change in percentage points. Thus, the change from -5% to 7% is a change (increase) of 12 percentage points.Do not try to calculate it as a percentage change. The change from -50 to 50 is 100*100/(-50) works out as -200% while the change from 50 to -50 is 100*(-100)/50 = -200%. One goes up, the other goes down but the % change is the same!

It istwo numbers are a percentage relationship between them orone number and a percentage change.

You do not. Percentage change (increase or decrease) makes sense only if both numbers are positive or both are negative. Consider the change from -50 to +50. You could calculate the percentage change as 100*(new-old)/old = -200% Now consider the percentage change from +50 to -50. -200% again! So, in percentage terms a change from +50 to -50 is the same as from -50 to +50.

How to find percentage? What if you need to calculate percentage increase, but not only by how much a number increased, but also the change in percentage increase between two numbers? The below online calculator will calculate percent increase, and it will also calculate percent decrease, and percent difference calculation as well --> the example will explain how it works.Math Example: How to calculate percentage increase, Decrease or Difference How to calculate percent increase between two numbers? To calculate percent difference, you need to follow these steps:1. Problem: You need to calculate percent % increase from 2 to 102. First Step: find the difference between two numbers, in this case, it's 10 - 2 = 83. Second: Take the difference, 8, and divide by the original number: 8/2 = 44. Lastly, multiply the number above by 100: 4*100 = 400%You're done! You calculated difference of a number in percent, and the answer is a percentage increase of 400%.

The absolute difference is 0.02. In relative terms, we could say that 0.07 is 40 percent larger than 0.05. This calculated by dividing the difference of the two numbers by the lesser of the two: (0.07 - 0.05) / 0.05 = 0.02/0.05 = 0.4 = 40 percent.To calculate the change, just find the difference between the numbers given.0.07 â€“ 0.05 = 0.02.If you are supposed to find the percentage of change then,Percentage of change = (Change * 100)/initial value.= 0.02*100/0.05= 2/0.05= 200/5= 40%The change between 0.05 to 0.07 is 40%Source: www.icoachmath.com

you ask someone