We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

# Tech Helproom

It's free to register, to post a question or to start / join a discussion

# Excel percentage calculation using office 2010

Terry Brown
Resolved

Likes # 0

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

Likes # 0

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

Likes # 0

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

Likes # 0

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

lotvic

Likes # 0

I think BRYNIT is more tired than I am..

Woolwell

Likes # 0

See Maths is fun

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

lotvic

Likes # 0

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

Likes # 0

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

Likes # 0

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

Likes # 0

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

lotvic

Likes # 0

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.

Android M Developer Preview announced at Google I/O: Android M UK release date and new features. Wh?......

Why I think the Apple Watch sucks and you'd be mad to buy it

Ben & Holly's Game of Thrones titles spoof is delightfully silly

Mac OS X 10.11 release date rumours: all the new features expected in Yosemite successor