ExcelBanter - How to create data tables and is there a payback period function

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to create data tables and is there a payback period function (https://www.excelbanter.com/excel-worksheet-functions/99939-how-create-data-tables-there-payback-period-function.html)

Austen T

How to create data tables and is there a payback period function

I have read Execl help but can't work out how to create an excel table which
will calculate the NPV for varying selling prices

Also is there a function for calculating pay back period

All times are GMT +1. The time now is 05:16 AM.