Solved

How to calculate a percentage

Posted on 2014-12-27
2
116 Views
Last Modified: 2014-12-27
I am trying to calculate an estimated value for year 2008 knowing the 2014 & 2011 values.
If 2014 value is $800,000, 2011 value is $560,000 the the % increase is (800000-560000)/560000 = 43%.

How can I get an estimated value for 2008?

It's driving me nuts
0
Comment
Question by:weeph
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
Simon earned 500 total points
ID: 40519939
$392,000

I looked at it the other way round. The 2011 value is 70% of the 2014 value. 2008 is another 3 years back (an equal step) and if the rate of decrease is linear it would be 70% of 560,000, which is 392,000

Looking at it another way, 2014 value is 143% of 2011 value so to reverse that and go backwards use the inverse of 1.43, which is 0.7.
0
 

Author Closing Comment

by:weeph
ID: 40519965
Absolutely spot on thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Odd Behavior 5 71
Discrete Values 2 62
PHP Loan Calculation formula help. 8 82
Math home work questions 5 109
A Guide to the PMT, FV, IPMT and PPMT Functions In MS Excel we have the PMT, FV, IPMT and PPMT functions, which do a fantastic job for interest rate calculations.  But what if you don't have Excel ? This article is for programmers looking to re…
Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question