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.

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

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

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 find the result …

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 set of …

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 differs from Scenarios and Data Tables in that it takes a result and projects backwards to determine possible input values that produce that result. Each scenario can accommodate up to 32 …

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.

Se sabe o resultado que pretende de uma fórmula mas não tem a certeza sobre quais os dados necessários para obter esse resultado, utilize a função Atingir Objetivo do Excel.