I'm using goal seek as a macro to solve a quadratic equation. I have
three variables that I adjust to solve the equation, I hold two
constant and solve for the third using goal seek. Sometimes goal seek
will give me the negative solution, I was wondering if there was any
way to force goal seek to only give me the postivie solution.
-Private Sub CommandButton1_Click()
Range("C47").GoalSeek Goal:=0.9999, ChangingCell:=Range("I4")
ActiveWindow.SmallScroll Down:=0
End Sub-
Thanks,
Kainoa
--
Kainoa
------------------------------------------------------------------------
Kainoa's Profile:
http://www.excelforum.com/member.php...o&userid=28856
View this thread:
http://www.excelforum.com/showthread...hreadid=544445