Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel Masters?
I need to develop an Excel formula that will allow me to take an amount and be able to have it display how much something would double in a certain amount of time. For example, I take a penny, and see how it would double every day. So for the first day it would be 1 cent the next it would be 2 and the third day it would be 4 and so on and so forth for a set amount of time. If you know how I can do this, please post the formula. Thanks.
1 Answer
- AQuestionMarkLv 71 decade agoFavorite Answer
Say A1 has start date 01-Jun-08
B1 has end date 30-Jun-08
=TEXT(POWER( 2,DATEDIF( A1,B1,"D" ))/100, "$##,##0.00")
you can vary the start date and the end date, the example above gives you $5,368,709.12