Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy lifting when it comes to finding those unknowns. When you have a formula in Excel but need to find the value of one ...

To get Solver to work, you need ... in this column. Excel considers blank cells to be 0s so you needn’t fill in these cells with anything to start. Solver will do that for you.

The Solver add-in for Microsoft Excel is one of the most important, so we can understand the frustrations when users cannot get it to work as they hope. In older versions of Excel, folks had to ...