IRR Syntax
On Jul 13, 10:14 am, Bruce wrote:
Is there a syntax that I can use that recognizes that my investment
amt and resulting cash flows are not necessarily neatly lined up?
Investment is in A5 and resulting cash flows are C10:C20
Try IRR((A5,C10:C20))
The inner parentheses are significant. See the reference operators on the
Help page "About calculation operators".
|