Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
how do I calculate % increase?
Last year my quarterly bill was £158.55 and this year my quarterly bill is £194.21.
How do I calculate the % increase?
I can sort of work it out by using excel but there must be an easier way than having a column of percentages from 1 to 100% and downward filling until I get matching figures?
I get 22.4%
How do I calculate the % increase?
I can sort of work it out by using excel but there must be an easier way than having a column of percentages from 1 to 100% and downward filling until I get matching figures?
I get 22.4%
0
Comments
-
Hi, you calculation is correct. To work out the percentage increase you can do the following calculation. new value - the old vale % old vale x 1000
-
First work out the difference between last quarter and this quarter i.e. £194.21 - £158.55 = £35.66
Then you have to find out what percentage £35.66 is of last quarter's bill so £35.66 divided by £158.55 = 0.2249132
Multiply this by 100 and you've got your percentage increase - 0.2249132 X 100 = 22.49132
So your increase is just under 22.5 %.
I'm sure there are simpler and quicker ways to do it, but that's how I do it.0 -
£194.21 minus £158.55 = £35.66.
£35.66 divided by £158.55 = 0.2249 multiply by 100 = 22.49%
Edit. Posts crossed - great minds etc0 -
u just do
194.21 / 158.55 = 1.22491
your percentage increase being 22.491%0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 356K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.3K Spending & Discounts
- 248.5K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards