goal seek problem

M

mpreddy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal Seek Problem 0
Goal seek - column reference 3
Macro help for goal seek 2
Vertical Multiple Goal Seek 0
Can I enforce Goal Seek to perform one iteration only? 2
Userform and Goal Seek 1
Goal Seek in a Macro 1
Help understanding Goal Seek Calculation 3

Top