View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Calculate NPV - Array must be flexible

What is NPV and how is it calculated?

RBS


"Helge's" wrote in message
...
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.