| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
goal seek problem
Hi
The goal seek function in one of my workbooks is sometimes returnin negatie results though there exists a positive value which i expect t receive. How can I give a guess value for goal seek like -0.09 in IR function which solves some IRR errors. Or is it possible to put som constraints for "changing cell" like "0" in the goa seek code. If an one has solutin please help Redd -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
goal seek problem
If a value must be positive, ensure that with ABS(value).
HTH, sulprobil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple yet complex scenario - goal seek problem | Excel Worksheet Functions | |||
| goal seek | Excel Discussion (Misc queries) | |||
| Problem with Goal Seek | Excel Worksheet Functions | |||
| I am having a problem calculating formulas using goal seek | Excel Discussion (Misc queries) | |||
| Goal Seek | Excel Worksheet Functions | |||
Linear Mode
