Ivan
|
| posted on 13/8/18 at 01:55 PM |
|
|
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! 
|
|
|
|
|
nick205
|
| posted on 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
|
| posted on 13/8/18 at 04:30 PM |
|
|
method 1 to show % increase.
|
|
|
HappyFather
|
| posted on 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
|
| posted on 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
|
| posted on 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
|
| posted on 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...!!!
Beware of what you wish.. for it may come true....
|
|
|
