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

hide cookie message
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

Like this post
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

Like this post
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.

Like this post
lotvic

Likes # 0

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

Like this post
lotvic

Likes # 0

I think BRYNIT is more tired than I am..

Like this post
Woolwell

Likes # 0

See Maths is fun

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

Like this post
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

Like this post
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.

Like this post
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)

Like this post
bumpkin

Likes # 0

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

Like this post
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.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Where to buy iPhone 6 and iPhone 6 Plus in the UK: Launch day price, deals and contracts

IDG UK Sites

Is Apple losing confidence in itself?

IDG UK Sites

Professional photo and video techniques for perfect colours

IDG UK Sites

How (and where) to buy an iPhone 6 or iPhone 6 Plus in the UK. Plus: What to do if you pre-ordered...