Excel formula question.
Thank you. I was on the right track before. I was missing the - for the PV
and it was giving me an error.
"driller" wrote in message
...
Jaycee,
I prefer to use Dana's 1st formula (NPER), it falls under the financial
category of excel....hope you are not confused between other
formulas...more
money...
"Dana DeLouis" wrote:
...the compound interest formula...
Perhaps as an Excel Formula:
=NPER(6%/12,0,-750,1000)
Or:
=LOG(1000/750)/LOG(1+6%/12)
--
HTH :)
Dana DeLouis
Windows XP & Office 2003
"Jaycee" wrote in message
...
I'm trying to figure out the compound interest formula to tell me how
long
it will take for investment to reach a certain amount.
E.g.
I have $750 that I can invest at 6%. How long will it take, compounded
monthly, to reach $1000.
Thanks.
|