Goal Seek
The Goal Seek add-on for Google Sheetsᵀᴹ enables users to calculate the required value of a cell to achieve a desired formula value in another cell.
Fiche mise à jour le :11 mai 2023
Compatible avec :
3 M+
Présentation
If you know the result you need from a formula, you can use the Goal Seek add-on to find the missing value needed to achieve it. You can use the add-on to conduct break-even analysis, or determine subcomponent targets when modeling future outcomes. You can also modify parameters, like max iterations, tolerance and max execution time that Goal Seek uses to determine a solution or load previous calculations. There are three components to configure: - the target value - the changing cell (where the formula is) - the output value to achieve Learn more about the add-on on support.google.com/docs/answer/9506732.
Informations supplémentaires
sell
TarifsSans frais
code
Développeur
email
Assistance
lock
Règles de confidentialité
description
Conditions d'utilisation
flag
SignalerSignaler comme inappropriée
Recherche
Effacer la recherche
Fermer le champ de recherche
Applications Google
Menu principal