Goal Seek

[Gav Dent]

Is there anyway to use the Goal Seek function in a formula?

My problem is that I have a spreadsheet with several columns which I will be
updating on a monthly basis, and have some cells in each column where I will
need to do a goal seek to change an adjustment factor to give me the results
I need.

I don't want to have to do this each month for several columns, so want to
do something more automated but I can't see that I can use Goal Seek as a
formula.

Thanks in advance for any help.

Gav

 

[JE McGimpsey]

I don't want to have to do this each month for several columns, so want to
do something more automated but I can't see that I can use Goal Seek as a
formula.

Goal Seek can't be used in a formula. However, you can record a macro
while performing the goal seek, and run that monthly.