Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using goal seek to solve for a desired IRR ("To Value") by modifying the
initial cash outflow ("By Changing Cell") that is followed by a fixed series of cash inflows. The values I input for IRR are whole % (ex. 15.0%, 30.0%, etc) however, the resulting IRR that is calculated through goal seek is never a round number. In most cases, it will round to my desired result but occasionally it will leave me off by 0.1% (rounded). Anybody know why the result doesn't equal the exact number i enter in the "To Value" field? Thanks Curt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
goal seek circular reference | Excel Discussion (Misc queries) | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek | Excel Discussion (Misc queries) | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) |