View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mpreddy mpreddy is offline
external usenet poster
 
Posts: 1
Default 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