As with the XNPV function, the XIRR function cannot be used unless you have installed the Analysis Toolpak.
与xnpv函数一样必须安装分析工具库才能使用xirr函数。
Check if the box for "Analysis ToolPak" is ticked or not. A ticked box means you already have it and you are ready to use if right away!
检查是否为“分析工具库”的框中打勾。勾选复选框时,意味着你已经拥有它,如果马上使用,你已经准备好!
You can perform all the statistical functions that you need in Excel with built-in Excel functionality using "Analysis ToolPak" add-in (there is no need to use KaddStat).
您可以执行所有的统计功能,你需要在Excel中内置Excel功能使用“分析工具库”中添加(没有必要使用KaddStat的)。
应用推荐