How to calculate period

Its a simple compound interest problem.
e.g
i need to find in how many years will a a sum double at 10% p.a compound interest

Yes, that's exactly what NPER() does.

=NPER(10%,0,-100000,200000)

Gives you 7.272541 years.

--
Kind regards,

Niek Otten

"manan" <manan.27p5wz_1147441504.1676@excelforum-nospam.com> wrote in message
news:manan.27p5wz_1147441504.1676@excelforum-nospam.com...
|
| Its a simple compound interest problem.
| e.g
| i need to find in how many years will a a sum double at 10% p.a
| compound interest
|
|
| --
| manan
| ------------------------------------------------------------------------
| manan's Profile: http://www.excelforum.com/member.php...o&userid=34216
| View this thread: http://www.excelforum.com/showthread...hreadid=541540
|