#1
|
|||
|
|||
Missing percentages in a range
I have the following info:
A timeline in the form of a percentage - 0-100% (0, 1, 2, ... 100%. Let's name this t and p=percentage progress So: at t-40 p=0, t-45 p=0,56%, t-50 p=1,68%, t-55 p=5,94%, t-60 p=12,61%, t-65 p=21,31%, t-70 p=32,4% and it continues to t-100. What is excel formula to calculate the missing percetages for each increment of t. Therefore, what is the % for t-1, t-2, t-3, t-4 and t-6, t-7 ....... Kind regards Philzar |
#2
|
|||
|
|||
p appears to be exponential with respect to t i.e. p(45)-p(40) < p(50)-p(45) < p(55)-p(40). I'm not exactly sure how to come up with the exact formula for the data.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I autofill cells using percentages from another spreadsheet? | Baldeagle | Excel Programming | 25 | 03-24-2016 03:05 AM |
autofill cells using percentages from another spreadsheet | Baldeagle | Excel Programming | 1 | 01-15-2015 01:28 PM |
How to calculate percentages??? | fabthi | Excel | 3 | 04-13-2012 12:08 PM |
Charting percentages within a percent | Tom0822 | Excel | 0 | 03-05-2012 08:50 PM |
use VBA to name a range | g48dd | Excel Programming | 7 | 06-20-2011 06:34 AM |