IRR Syntax

B

Bruce

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

It just seems as if I'm missing something simple. I know I can copy all the
info to another location (X5:X16) and line it up to use the basic syntax.

Thanks
 
J

joeu2004

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
Click to expand...

Try IRR((A5,C10:C20))

The inner parentheses are significant. See the reference operators on the
Help page "About calculation operators".
 
Top