I have never used Excel 2000 but other versions have a goalseek function.

Check it out in help.

Or possibly load the solver add-in which was available in 2000


Gord Dibben MS Excel MVP

On Sun, 6 Sep 2009 06:35:01 -0700, Tony
wrote:

Hi,

how do I find the what if analysis function in ver. excel 2000?


Regards
Tony