Goal seek output

K

Kainoa

I'm using goal seek as a macro to solve a quadratic equation. I hav
three variables that I adjust to solve the equation, I hold tw
constant and solve for the third using goal seek. Sometimes goal see
will give me the negative solution, I was wondering if there was an
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,
Kaino
 

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

Parameter Input for Goal Seek 2
Goal seek - column reference 3
Loop several sheets - part 3 - Dave Peterson - Goal seek 4
vba goal seek in 07 envoking sumcolor UDF 0
Do Loop Goal Seek won't End Sub 2
Goal seek - column reference - user input message 0
Goal Seek with dynamic Goal Seek 1
Using Goal Seek without a macro 1

Top