Exploring what-if scenarios using Goal Seek

- Excel's "Goal Seek" feature located on the Data tab…under "What If Analysis" is a powerful tool…for letting us come up with a different answer.…Now, you could describe this in a fanciful way.…I've got a formula here that's adding up data…from columns F and G, I'd like to have a different answer.…Let's connect this with a real life situation.…This is an organization that's going to provide…bonuses for people based on their job ratings,…and there's a formula in column G…that's going to be using this table here to the right.…And in effect, the table will give us answers saying…if your job rating is a 2 you'll get a bonus of $375.…

If it's a 3, it's $1500. If it's 4 or more, $3000.…And in this table, these numbers are related to one another.…The 3000 here is a pure number,…the 1500 here is half of that, and…the 375 here is a quarter of that.…Now, you're the chief financial officer…and you've decided that the company can afford to spend…$28.5 million on the combination of these two.…This is the formula right here in this cell here.…