Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2015, 05:39 AM
philzar philzar is offline Missing percentages in a range Windows 7 64bit Missing percentages in a range Office 2010 64bit
Novice
Missing percentages in a range
 
Join Date: Jul 2015
Posts: 1
philzar is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-13-2015, 09:54 AM
gebobs gebobs is offline Missing percentages in a range Windows 7 64bit Missing percentages in a range Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing percentages in a range Can I autofill cells using percentages from another spreadsheet? Baldeagle Excel Programming 25 03-24-2016 03:05 AM
Missing percentages in a range autofill cells using percentages from another spreadsheet Baldeagle Excel Programming 1 01-15-2015 01:28 PM
Missing percentages in a range 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
Missing percentages in a range use VBA to name a range g48dd Excel Programming 7 06-20-2011 06:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft