Goal Seek Formula

[David]

From: "David" <[email protected]>
Subject: Goal Seek formula
Date: Monday, 12 January 2004 22:09

Is there a goal seek formula that does the same thing as the goal seek
add-in?

 

[Bernard V Liengme]

Hi David,
There cannot be a 'formula' to do this since a formula/function cannot
change the value of any cell other than the one it is in.
You could make a VBA subroutine.
Bernard

 

[Niek Otten]

Please don't post to more than one group.

See my anser in other ng

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel