While I appreciate the craftiness of teaching to use Excel's Goal Seek function to solve an equation, I find it somewhat dangerous.
How have you solved Formulas using Excel or other techniques? How have you solved Formulas using Excel or other techniques
You can download a sample of the above here: Download Sample File Select Cancel to return to the previous value To value: 60 This is the value we want to achieveīy changing cell: B3 – This is our x value cellĮxcel shows us that it has found a solution and that y ( C3) =60 when x ( B3) = 374.60 Goto the Data, What-If Analysis, Goal Seek menu To use Goal Seek to find what value of x ( B3) will result in y ( C3) = 60, Start a new file and in C3 (our y cell) type: = 2*10^7*B3^-2.146 To use Goal Seek we need to put our formula into a cell. Goal Seek is an inbuilt function in Excel that searches for a solution to a model/formula by iteratively trying source cell values until a solution is found.īefore we start, Excel doesn’t understand the concepts of x and y, but we can use cells for these instead
Goal Seek is located in the Data, What-If Analysis, Goal Seek menu We can use Excel’s Goal Seek function to assist us here Lets look at how this can be solved using Excel. How can we solve this equation using Excel? ” I did its fitting using Excel and got an equation. This week at the Chandoo,org Forums, Usman asked,