XNPV function - Microsoft Support
Returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
XNPV 函数 - Microsoft 支持
语法. XNPV (rate, values, dates) XNPV 函数语法具有下列参数：. Rate 必需。. 应用于现金流的贴现率。. 值 必需。. 与 dates 中的支付时间相对应的一系列现金流。. 首期支付是可选的，并与投资开始时的成本或支付有关。. 如果第一个值是成本或支付，则它必须是负值。.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016