Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Solve Equations in Excel using Solver Add-in Solver Add-in is a powerful and useful tool of Excel which performs calculations to give the optimal solutions meeting the specified criteria.

Minimize costs? Create a conference schedule with fewest early-morning sessions? In this excerpt from the book Data Smart, find out how to use Excel's free Solver add-in to do some data science ...