ExcelBanter - Payback Period

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Payback Period (https://www.excelbanter.com/excel-discussion-misc-queries/115467-payback-period.html)

Plum

Payback Period

Has anyone ever come across a function in excel that will calculate a payback
period? I always do it manually, as I'm not familiar with a function that
will do it for me.

Niek Otten

Payback Period

Look in HELP for the NPER() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Plum" wrote in message ...
| Has anyone ever come across a function in excel that will calculate a payback
| period? I always do it manually, as I'm not familiar with a function that
| will do it for me.

All times are GMT +1. The time now is 07:17 AM.