Goal Seek

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use goal seek on column 4
Button for goal seek?! 6
Rounded Result with Goal Seek 7
Parameter Input for Goal Seek 2
Correct cell value doesn't display 2
Goal seek via macro? 1
Goal Seek Question 1
Goal Seek on multiple rows/columns??? 0

Top