Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal seek output
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
goal seek circular reference | Excel Discussion (Misc queries) | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek | Excel Discussion (Misc queries) | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) |