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 |
All times are GMT +1. The time now is 05:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com