Using the Goal Seek Add-On in Google Sheets

28 November 2019
Adrian Francis

There are times when you need to find the best solution for a problem. It may be the selling price of an item and the number of items you need to sell to make a profit. Goal Seek, which is an add-on in Google Sheets will help to find the optimal solution. This is a powerful tool that enables you to set the output you want and then the sheet will work out what value you need to get you there. Goal Seek does this in a matter of seconds compared to manually trying to find the best solution.

Goal Seek in #GoogleSheets will help you find the optimal solution to a scenario. Click To Tweet


When I taught maths we would do this manually as part of an optimisation project and every time that you changed a value, you would manually recalculate the output, or adjust your chart to show the best solution. Goal Seek will test the different scenarios until you reach your goal. An example of this may be when you want to know the number of items you need to sell at a certain price to make a profit. The spreadsheet may look like this:

Become more efficient in finding solutions in #GoogleSheets by using Goal Seek. Click To Tweet


Goal Seek will adjust any value to meet that goal. You may want to change the selling price, or the variable cost of the item and run a series of ‘what if’ scenarios.

Watch this video to learn how to use Goal Seek in your Google Sheets.

So there you have it. A great way to further add functionality to Google Sheets by using Goal Seek. If you want to learn more tips on using Google Workspace tools, why not try one of our online courses?

Recent Posts

Here’s What
Our Clients Say

PR Industrya


In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...


Choose Industry:

Which Skills Checklist?


Nice Move Allstar!
You're about to get
awesome value in your
inbox that's going to make
life that little bit easier & sweeter!


Pop in your details below and we'll send you the PLD Checklist 📧

First time applying for MoE Funded PLD?

Get the Latest Blog Posts, New Tips And Tricks


NSW DoE Leadership Webinars


NSW DoE Leadership Webinars


Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: