From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Exploring what-if scenarios using Goal Seek

Exploring what-if scenarios using Goal Seek - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Exploring what-if scenarios using Goal Seek

- [Instructor] Excel's Goal Seek feature, 2 located on the Data tab under What-If Analysis, 3 is a powerful tool for letting us 4 come up with a different answer. 5 Now, you could describe this in a fanciful way. 6 I've got a formula here that's adding up data 7 from columns F and G, I'd like to have a different answer. 8 Let's connect this with a real-life situation. 9 This is an organization that's going to provide bonuses 10 for people based on their job ratings, 11 and there's a formula in column G 12 that's going to be using this table here to the right. 13 And in effect the table will give us answers saying 14 if your job rating is a two you'll get a bonus of $375. 15 If it's a three it's $1,500. 16 If it's four or more, $3,000. 17 And in this table these numbers are related to one another. 18 The 3,000 here is a pure number, 19 the 1,500 here is half of that, 20 and the 375 here is a quarter of that. 21 Now, if you're…

Contents