Board logo

How do you show a % increase
Ivan - 13/8/18 at 01:55 PM

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!


nick205 - 13/8/18 at 02:06 PM

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]


cliftyhanger - 13/8/18 at 04:30 PM

method 1 to show % increase.


HappyFather - 13/8/18 at 05:24 PM

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%


MikeR - 13/8/18 at 05:36 PM

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%.


02GF74 - 13/8/18 at 05:40 PM

^^^^^^^ 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.


Angel Acevedo - 14/8/18 at 02:48 PM

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...!!!