Calculates an investment's net present value, using a series of cash flows that are potentially irregular.
XNPV(discount: Number, сashflowamounts: Array, сashflowdates: Array) => Number
The discount rate of the investment over one period.
A range of cells containing the income or payments associated with the investment.
A range of cells with dates corresponding to the cash flows in сashflow amounts
cash1 = [1,2,3,4,5]dates1 = ["2019-07-11T13:06:15+03:00","2019-07-12T13:06:15+03:00","2019-07-13T13:06:15+03:00","2019-07-14T13:06:15+03:00","2019-07-15T13:06:15+03:00"]cashSmall = [1,2,3]datesSmall = ["2019-07-11T13:06:15+03:00","2019-07-12T13:06:15+03:00","2019-07-13T13:06:15+03:00"]