Printable Version | Subscribe | Add to Favourites
New Topic New Poll New Reply
Author: Subject: How do you show a % increase
Ivan

posted on 13/8/18 at 01:55 PM Reply With Quote
How do you show a % increase

If you were writing a report about increases in price how would you show the increase?

Like This assuming old is 6 pounds and new is 10 pounds
(10-6)/6 = 66.66%

or

10/6 = 166.66%

I can't believe I don't know but my mind is tired after a whole day since 05H00 of spread sheet work and I have managed to totally confuse myself!

View User's Profile View All Posts By User U2U Member
nick205

posted on 13/8/18 at 02:06 PM Reply With Quote
First method looks the correct way to me.

Checked by 6.00 x 1.6666 = 9.99 or 6 + 66.66% = 9.99 (Windows calculator)

[Edited on 13/8/18 by nick205]

View User's Profile View All Posts By User U2U Member
cliftyhanger

posted on 13/8/18 at 04:30 PM Reply With Quote
method 1 to show % increase.
View User's Profile View All Posts By User U2U Member
HappyFather

posted on 13/8/18 at 05:24 PM Reply With Quote
Actually it should be old price plus the increase equals new. Being the increase a percentage of the old price, we have that
increase = old*x
being x the increase in percentage of the old value.

So...
old + old*x = new
I find it easier to do like
old * (1 + x) = new
6 * (1+x) = 10
1+x = 10/6
1+x = 1,666
x = 1,666 - 1
x = 0,666
So, 66%

Can also be done
old + old*x = new
old*x = new-old
6*x = 10-6
6*x = 4
x = 4/6
x = 0,666
So, 66%

View User's Profile Visit User's Homepage View All Posts By User U2U Member
MikeR

posted on 13/8/18 at 05:36 PM Reply With Quote
Just checked with the accountant wife and she says 66%.

Eg if it's 100 pounds this week and next week it's 102 pounds you'd say it was a 2% increase not 102%.

View User's Profile View All Posts By User U2U Member
02GF74

posted on 13/8/18 at 05:40 PM Reply With Quote
^^^^^^^ holy crap, is that meant to simply things?..

Google explains it perfectly.

work out the difference (increase) between the two numbers, I. e. old price subtracted from new..

Then: divide the increase by the original number and multiply the answer by 100. If your answer is a negative number then this is a percentage decrease.






View User's Profile View All Posts By User U2U Member
Angel Acevedo

posted on 14/8/18 at 02:48 PM Reply With Quote
quote:
Originally posted by Ivan
If you were writing a report about increases in price how would you show the increase?

Like This assuming old is 6 pounds and new is 10 pounds
(10-6)/6 = 66.66%

or

10/6 = 166.66%

I can't believe I don't know but my mind is tired after a whole day since 05H00 of spread sheet work and I have managed to totally confuse myself!



I hope it is only an example...
As 66% increase is A LOT...!!!





Beware of what you wish.. for it may come true....

View User's Profile E-Mail User Visit User's Homepage View All Posts By User U2U Member

New Topic New Poll New Reply


go to top






Website design and SEO by Studio Montage

All content © 2001-16 LocostBuilders. Reproduction prohibited
Opinions expressed in public posts are those of the author and do not necessarily represent
the views of other users or any member of the LocostBuilders team.
Running XMB 1.8 Partagium [© 2002 XMB Group] on Apache under CentOS Linux
Founded, built and operated by ChrisW.