Hi Caroline,

Look in HELP for the NPER() function
Or, even better, look at this article, whicht explains all these related
functions:

http://office.microsoft.com/en-us/ex...117451033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"caroline" wrote in message
...
hello,
I am doing a cash flow and NPV calculation. so far so good....
However I also want to find out the year of my return of investment (i.e.
when the cash flow turns from a Negative to a Positive). Any idea how I
could
do this easily?
thanks
--
caroline