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.