How long does it take to wipe out my holdings.
Posted by Tim Stadler on January 24, 2002 6:08 PM
I can hold my own in Excel, but I'm stumped here.
I have one value in cell A1. It represents my current holdings for example. In the next column are values representing the how many of my holdings are going to be subtracted weekly from A1. These are weekly "withdrawals", so the cells would be B1 to B52 (representing the years's withdrawals.)
What I need to do is find out how many weeks it would take to deplete cell A1, but I can't think of a formula that works.