Look in HELP for the NPER function. Don't forget to divide your % by 12 if
you need the number of months.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Maria" wrote in message
...
I am trying to set up a spread sheet where I can determine the number of
months it will take after investing about $2mil at a 10% rate to see my
first
return.
|