Join Dennis Taylor for an in-depth discussion in this video Exploring what-if scenarios using Goal Seek, part of Excel Tips Weekly.
- View Offline
- 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.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.