Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop IRR calculation at a particular year...
Hello all!! Hopefully this will be an easy one. I have a sheet to calculate
IRR. The sheet holds 50 years of information. The workbook I'm using will rarely require all 50 years worth of information. Is there a way to tell Excel, depending on the value of another cell, to stop the IRR calculation on a particular year? The sheet automatically calculates all 50 years. But most of the time we just need 10 or 20 years included in the calculation. Any help will be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Year Calculation | Excel Worksheet Functions | |||
how can I stop Excel Advancing the year by 1 when I enter a date? | Excel Discussion (Misc queries) | |||
Fiscal Year Calculation | Excel Worksheet Functions | |||
Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
Is the IRR calculation based on cash flows at beginning of year? | Excel Worksheet Functions |