=NPER(6%,0,-750,1000)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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.
|
|