Constrained Nonlinear Optimization in Excel without the Excel Solver

Constrained Optimization in Excel

Here we see how to do constrained optimization with an Excel spreadsheet function. The spreadsheet function MinimizeNonnegative() imposes a nonnegativity constraint on the variable. This is useful when you’re solving for something that can’t be negative, like energy or an interest rate.