Multi area Array using IRR function

[Malakite]

I'm having trouble getting this formula to work.

=IRR(INDIRECT(("B26:"&D12&"26"&",BS26")),0.01)

Cell D12 contains the column letter that changes based on a user inputted
hold period. The actual formula =IRR((B26:V26,BS26),0.01) works fine which is
the same forumla that shows when stepping through the function using the
error check.

Any help appreciated.

[JoeU2004]

"Malakite" <Mala...@discussions.microsoft.com> wrote:
> I'm having trouble getting this formula to work.
> =IRR(INDIRECT(("B26:"&D12&"26"&",BS26")),0.01)

Ostensibly, you should write:

=IRR(INDIRECT("(B26:"&D12&"26"&",BS26)"),0.01)

But it appears that INDIRECT does not support range union reference. Most
Excel functions do not.

The following should work:

=IRR((INDIRECT("B26:"&D12&"26"),BS26),0.01)

----- original message -----

"Malakite" <Mala...@discussions.microsoft.com> wrote in message
news:A3C10236-B9C4-4BFE...@microsoft.com...

[Malakite]

Thanks

That works fine. thats how I originally had the formula but the parenthesis
were in the wrong places. I originally had
=IRR(INDIRECT(("B26:"&D12&"26"),BS26),0.01). Thank you for the help.