Goal Seek

  • Thread starter Thread starter mikecookaxa
  • Start date Start date
M

mikecookaxa

is there a way to use goal seek so that when I change variable
effecting the goal that the cell that you're trying to vary will chang
along with it?


for example


Goal:

Value = $0 in 10 years
IR = 5%
pymt is changing cell

change the IR to 6% I would like the pymt to automatically change alon
with it


Thank
 
Back
Top