software

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(quot;C47quot;).GoalSeek Goal:=0.9999, ChangingCell:=Range(quot;I4quot;)
ActiveWindow.SmallScroll Down:=0
End Sub-

Thanks,
Kainoa--
Kainoa
------------------------------------------------------------------------
Kainoa's Profile: www.excelforum.com/member.php...oamp;userid=28856
View this thread: www.excelforum.com/showthread...hreadid=544445