Definition. This function returns the internal interest rate for a series of not-necessarily periodic payments in the intra-annual scope.
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 ...