| 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. |
| 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 | |||
Threaded Mode
