XNPV
Description
Returns the net present value based on the specified discount rate, payment/income
amounts, and payment dates.
Syntax
XNPV(
rate
,
values
,
dates
)
- rate: The discount rate.
- values: The array of numeric values representing the payments and income.
- dates: The array of dates that correspond to the payment and income values.