Multi area Array using IRR function
"Malakite" 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" wrote in message
...
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.
|