Take a look at the NPER() function in XL Help.

In article ,
Kake wrote:

is there a formula to which i can type in a cell that well analyse
information given in the cells above to find out how long a project would
take before it is paid back???