Excel Spreadsheet Function to Optimize Cells (without Using the Excel Solver) Version 6
The Excel Solver is a powerful tool for solving complicated problems. But what if you want something smaller and more compact like… an Excel spreadsheet function?
MinimizeNonnegative() combine the power of a nonlinear optimizer with the convenience of a spreadsheet function. Unlike the Excel Solver, these functions automatically respond to changes in the spreadsheet and recalculate like any other formula. As an added bonus,
MinimizeNonnegative() can optimize some things that the Excel Solver cannot.