This is where the Solver tool comes in handy.

It's a simple What-If analysis tool that can be used for basic projections, but you might have a more complex scenario where you are unsure of multiple variables including your goal. The outcome was a set value that Excel then used to calculate another value that would help you define your solution. With the Goal Seek tool, you found values that can be used to determine an outcome.