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

goal seek problem
 

If a value must be positive, ensure that with ABS(value).

HTH,
sulprobil