If you know the result you need from a formula, you can use Goal Seek to find the missing value needed to achieve it.
For example, Goal Seek can be used:
- To conduct a break-even analysis for a business.
- To find out what score you need on your next test in order to earn the overall class grade you want.
To find your target values, install the Goal Seek add-on to Google Sheets. This add-on is only available in English.
Find a target value
- Di komputer Anda, buka Google Spreadsheet.
- Di bagian atas, klik Ekstensi Goal Seek Add-on Open.
- Isi spreadsheet dengan nilai yang Anda miliki dan formula yang perlu diselesaikan.
- Klik sel yang berisi formula.
- Di sebelah kanan, di samping “Tetapkan sel”, klik Batasi sel yang dipilih .
- Di bagian “Nilai”, masukkan nilai target yang ingin Anda capai.
- Klik sel berisi nilai tidak dikenal yang ingin Anda temukan.
- Di sebelah kanan, di samping “Dengan mengubah sel”, klik Batasi sel yang dipilih .
- Klik Selesaikan.
Learn about scripts and add-ons
Add-ons are covered by Google Apps Script Additional Terms.