If you know the result you want from a formula but aren't sure which input is needed to get that result, use Excel's Goal Seek feature.

If you know the result that you want from a formula, but you're not sure what input value the formula requires to get that result, you can use the Goal Seek feature.

If you know the result to expect from a formula, but don't know precisely what input value the formula needs to get that result, use the Goal-Seek feature. See the article Use Goal Seek to …

The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel.

You can use Goal Seek when you know the desired result of a single formula but not the input value the formula needs to determine the result.

Si conoce el resultado que desea de una fórmula pero no está seguro de qué entrada es necesaria para obtener dicho resultado, use la característica Buscar objetivo de Excel.

Goal Seek works differently from scenarios and data tables in that it takes a result and determines possible input values that produce that result. Like scenarios, data tables help you explore a …

数式から計算結果がわかっているのに、その結果を得るための入力値がわからない場合、Excel のゴール シーク機能を使用します。

如果您知道由公式可得的结果，但不确定为获得此结果所需的输入值，那么请使用 Excel 的单变量求解功能。

如果您知道您想要從公式得到的結果，但不確定需要哪些輸入才能取得結果，請使用 Excel 的「目標搜尋」功能。