Use Goal Seek in Excel to find a target value

Goal Seek is a great feature in Excel to find a target value. You can find Goal Seek within the Data Tab under the what-if button. In this example, I will share with you how to answer how much new revenue much we achieve to produce $10,000 in profit.

goal seek profit

Goal Seek options setup

goal seek setup

Goal Seek Results: The value is $8,050 in new product revenue will yield a profit of 10K.

goal seek results

By Steve Chase|2018-06-07T23:45:08-05:00April 11th, 2018|Excel|0 Comments

About the Author: Steve Chase

Steve Chase grew up in Dayton, OH but now calls San Antonio, TX home along with his entrepreneur wife, Erin, and their 4 sons. Steve founded Sequentia Solutions in 2017 to help small business owners grow their business with practical and effective solutions. Steve's #1 Clifton StrengthsFinder skill is Learner which comes in handy while he teaches others how to best use various business software applications like QuickBooks Online and Excel. Steve is an active volunteer leader with the Boy Scouts and treasures the lessons he learned while participating in Scouts as a youth on his path to Eagle. Steve enjoys drinking coffee, a good book, visiting art museums, and doing math problems using a brand new sharpened #2 pencils.