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 ...