XIRR()
Syntax. XIRR(Values,Dates,Estimated_Value)
Definition. This function returns the internal interest rate for a series of not-necessarily periodic payments in the intra-annual scope.
Arguments
Values (required) The (actual and/or expected) surpluses from disbursements and deposits, arranged without gaps in a column. Each value stands for a date. Negative surpluses have a minus sign.
Dates (required) The dates for the surpluses. The order must correspond to the payments in the argument Values. The first date specifies the start of the evaluation. All others must be after this date (without necessarily being in a specific order). The error value
#NUMBER!indicates that this requirement might not have been met.Estimated_Value (optional) For mathematical ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
