You can use the Goal Seek command on the Tools menu to reach a target value for one cell by changing the value in another cell.

选择“工具”菜单中的“单变量求解”命令，可改变可变单元格的值而寻求目标单元格的最优解。

youdao

You can use the Goal Seek command on the Tools menu to reach a target value for one cell by changing the value in another cell.

选择“工具”菜单中的“单变量求解”命令，可改变可变单元格的值而寻求目标单元格的最优解。

youdao