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,
0 kommentar(er)
