So I clicked "Browse" on the bottom and select Solver.Xlam.Īfter this error pops up, the location it is looking for Solver.Xlam at resets to the previous location. When I search on OSX I find the solver is at /Applications/Microsoft Office 2011/Office/Add-Ins. Press with left mouse button on 'By Changing Cells:' button and select B1:B11. Type in 'Value of:' window the summed value 2615,4. Press with left mouse button on 'Set Target Cell:' button. Press with left mouse button on 'Solver'. I realized that the address it thinks the solver is at is where the solver is on my PC, but not where it is on OSX. Press with left mouse button on 'Data' in the Ribbon.
You can add an IFS function in Excel 2016, 2013 or your copy of Excel 2010, or 2007 with the Excel PowerUps add-in. Excel 365 or Excel 2019 introduced a new function called IFS. I went into the developer side, and went to Tools -> Reference, and found that Solver.Xlam is missing. You can add the IFS Function to Excel 2016, 2013, 2010, and 2007. I remembered this happening on the PC side before I enabled the solver, so I went into Tools -> Add-ins and then enabled the Solver.Xlam. When I tried to compile the project, it says "Compile Error: Can't find Project or Library". I then tried to use this same program on Excel 2011, and ran into an issue.
I made sure it worked on both Excel 2010 and Excel 2013 for PC. I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel.
0 kommentar(er)
