3/22/2023 0 Comments Does excel for mac have solver![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |