Create the same criteria type, "int", for the nGadgets cell. Click the "Solve" button. Excel computes the optimal values for your objective formula's variables (e.g., 19 widgets and 1 gadget).

The first step in running regression analysis in Excel is to double-check that the free plugin Data Analysis ToolPak is installed. This plugin makes calculating a range of statistics very easy.