# Excel percentage calculation using office 2010

Terry Brown 20:27 28 May 13
Locked

I have a start figure (e.g 2000) and an end figure (e.g.2156). I know how to get a percentage increase (i.e. 2000*4%), but how do I do it so I can use the two figures (2000 + 2156 to give me the percentage difference.

These two numbers are just an example, but I need a formula to work out a list of similar sums, and as a check-sum reverse it to show the original figures (in case of data error)

Thanks for looking

Terry

lotvic 22:57 28 May 13

2000*7.8% = 156

2000 times 7.8 divide by 100 = 156

Q. 156 is what percent of 2000

A. 156 divide by 2000 is 0.078 and 0.078 times 100 = 7.8

156/2000*100=7.8

http://www.mathatube.com/percent-finding-percent.html

BRYNIT 22:58 28 May 13

If you are trying to find out the percentage increase between 2000 and 2156

the calculation would be 2156/2000*100=107.8% increase

(2000*107.8%=2156)

If 2000 was in A1 and 2156 was in A2 it would be

=sum(A2/A1*100)

I hope this is what you are looking for.

lotvic 23:01 28 May 13

No, I think I went wrong, I'm a bit tired, wait for someone else :P

lotvic 23:44 28 May 13

I think BRYNIT is more tired than I am..

Woolwell 12:45 29 May 13

See Maths is fun

Formula =(2156-2100)/2100 and set number format as percentage. Should give 3%

lotvic 14:16 29 May 13

On re-reading, I think the question is not very clear, Terry can you give more details please:

"use two figures (2000 + 2156 to give me the percentage difference"

is percentage difference really what you want to know?

Percent Difference =SUM((2156-2000)/((2156+2000)/2))*100 answer is =7.5072 Percent Difference

Breakdown of calculations doing the bracket sums it comes out:

=SUM(156/(4156/2))*100 answer is =7.5072 Percent Difference

=SUM(156/2078)*100 answer is =7.5072 Percent Difference

http://ncalculators.com/number-conversion/percentage-difference-calculator.htm

bumpkin 14:30 29 May 13

Another way of looking at it if I understand the question correctly.

Take the difference between the two figures.

Divide by the original figure then multiply by 100 for percentage.

Ie. (156/2000)x100=7.8.

lotvic 14:32 29 May 13

I did it wrong way round if Q is: two figures 2000 and 2156, if so that would make a minus Percent Difference

=SUM((2000-2156)/((2000+2156)/2))*100 answer is =-7.5072 Percent Difference (note the minus sign)

bumpkin 14:38 29 May 13

Whoops, sorry Lotvic you said that yesterday 10.57pm I did not read it properly.

lotvic 17:02 29 May 13

bumpkin, no need for 'sorry' the more that post the merrier :)

I'm still not sure exactly which percent answer Terry is wanting - even tho' he said "percentage difference." I wonder if that is really what he means.

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch