Excel has a number of powerful tools for numerical analysis that can reduce complicated problems into fairly simple answers. Two of these that are covered in advanced Excel courses are Goal Seek and Solver.

Goal Seek: Looking For a Specific Answer

Goal Seek is the tool to use when you know the answer to an equation but don't know the input values to put out that answer.

Consider a simple example. You sell 100 units of a product per week for