O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required