Thank you for the clarification. Sometimes these formulas are so cryptic (to
me any way), I have trouble with them; even when trying to use help.

"OssieMac" wrote:

Lookup NPER function in help. Note that in the formula the interest is
entered as its real decimal value. eg. 4% is 0.04 (or 4/100) and regular
withdrawals is a negative amount eg. -50000.

--
Regards,

OssieMac


"ridgerunner" wrote:

I am not very good with financial worksheet functions and hope that someone
here can help. Is there a function that will return how long funds will last
if you earn a static interest rate and withdraw a static amount of money that
is more than the interest earned? Let's say, for example, the amount of
money is $1,000,000, the interest rate is 4% and the yearly withdrawal is
$50,000?