| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate NPV - Array must be flexible
I have a database with different dataset. That is the input to a
worksheet that calculate NPV. The array that I want to calculate NPV could look like this: 0 0 -200 50 50 50 -10 40 30 -20 -20 -20 The array for this dataset must be from -200 to 30. How could the arrayargument in the NPV-function look like? I am thinking of using OFFSET or some kind of Arrayfunction. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesn't this array formula calculate properly using VBA? | Excel Worksheet Functions | |||
| Calculate the result of an array in vba | Excel Programming | |||
| How can I calculate the minimum value of a VBA array? | Excel Programming | |||
| Help with excel array - select, add and calculate result | Excel Worksheet Functions | |||
| Using known arrays to calculate an array of new values | Excel Programming | |||
Threaded Mode
