you are very welcome....go ahead to enjoy excel functions....keep up on the
right track...read help files and make it a habit to click the Fx button. the
real brevity.

"Jaycee" wrote:

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.