Multi area Array using IRR function
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. |
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. |
Multi area Array using IRR function
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. "JoeU2004" wrote: "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. |
All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com