Suppose we need to run an advertising campaign for a defined budget of $45000 for a defined time frame of 10 weeks. We need to set up the data in the worksheet before using the Solver function to find the optimal solution. Adding Solver to Excel How to Use Solver in Excel After getting installed the Solver Add-in is available in the Analysis section of Data tab.įigure 3. From the available Add-ins dialog, select Solver Add-in and click OK button.On the left sidebar of the Excel Options, select Add-in > Manage box and select Excel Add-in and press Go button. ![]() But in Excel 2010 and later versions, go to File and then click Options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |