Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Area data ranges as Chart source | Charts and Charting in Excel | |||
set a permentant print area in a multi-sheet workbook | Excel Worksheet Functions | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
Multi-colour 'Area' chart | Excel Discussion (Misc queries) | |||
Multi-colour Area chart (see attachment) | Charts and Charting in Excel |