payback period
 

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???

payback period
 

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???

payback period
 

sorry but that formula was not much help as i was not given a interest
standard rate to use however look in the pay back period i have posted what
one of the sections is